using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using static GB5Shared.GB5Constant.Constant;

namespace MMDAL.CustomCode.PackDetail
{
    public class PackDetailDAL : IPackDetailDAL
    {
        public async Task<string>  UpdateQueryForPackNumber(int PackNumberId, int EntityId, string Status, double NetQuantity, int StoreId, double GoodQty = -1, double RejectQty = -1, int PackStatus = 0, int WorkCenterId = -1, double Pick = 0)
        {
            try
            {
                string Qry = "";
                if (EntityId == EntityConstant.OBJECTINSPECTION) //Inspection
                {
                    Qry = "UPDATE TPACKNUMBER SET STATUS = '" + Status + "' ,INSPECTEDSTATUS=2, NETQUANTITY = " + NetQuantity + ", STOREID = " + StoreId + ", PICK = " + Pick;
                    if (GoodQty != -1)
                    {
                        Qry += " , GOODQUANTITY = " + GoodQty;
                    }
                    if (WorkCenterId != -1)
                    {
                        Qry += " , WORKCENTERID = " + WorkCenterId;
                    }
                    if (RejectQty != -1)
                    {
                        Qry += " , REJECTEDQUANTITY = " + RejectQty;
                    }
                    Qry += " WHERE PACKNUMBERID = " + PackNumberId + "\r\n";
                }
                else if (EntityId == EntityConstant.OBJECTJOBCARD) //JobCard
                {
                    Qry = "UPDATE TPACKNUMBER SET STATUS = '" + Status + "' , NETQUANTITY = " + NetQuantity + " , STOREID = " + StoreId + " , WORKCENTERID = " + WorkCenterId + " WHERE PACKNUMBERID = " + PackNumberId + "\r\n";
                }
                else if (EntityId == EntityConstant.OBJECTPROCESSINGPRODUCTION) //ProcessingProduction
                {
                    Qry = "UPDATE TPACKNUMBER SET STATUS = '" + Status + "' , NETQUANTITY = " + NetQuantity + " , STOREID = " + StoreId;
                    if (GoodQty != -1)
                    {
                        Qry += " , GOODQUANTITY = " + GoodQty;
                    }
                    if (WorkCenterId != -1)
                    {
                        Qry += " , WORKCENTERID = " + WorkCenterId;
                    }
                    if (RejectQty != -1)
                    {
                        Qry += " , REJECTEDQUANTITY = " + RejectQty;
                    }
                    Qry += " WHERE PACKNUMBERID = " + PackNumberId + "\r\n";
                }
                else if (EntityId == EntityConstant.OBJECTPACKING) //Packing
                {
                    Qry = "UPDATE TPACKNUMBER SET STATUS = '" + Status + "' , PACKSTATUS = " + PackStatus + " , WORKCENTERID = " + WorkCenterId + " WHERE PACKNUMBERID = " + PackNumberId + "\r\n";
                }
                return Qry;
            }
            catch (Exception  )
            {
                throw  ;
            }
        }

        public async Task<string> DeletePackDetail(int BizTransactionTypeId, int ObjectHeaderTypeId, int ObjectHeaderId, int ObjectTypeId)
        {
            string Qry = "";
            Qry = "DELETE FROM TPACKDETAIL WHERE BIZTRANSACTIONTYPEID = " + BizTransactionTypeId + " AND OBJECTHEADERTYPEID = " + ObjectHeaderTypeId + " AND OBJECTHEADERID = " + ObjectHeaderId + " AND OBJECTTYPEID = " + ObjectTypeId;
            return Qry;
        }
    }
}