public int DeleteRecord(ref MaterialInwardReg Entity_MaterialInwardReg, out string strError)
{
int iDelete = 0;
strError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(MaterialInwardReg._Action, SqlDbType.BigInt);
SqlParameter pInwardId = new SqlParameter(MaterialInwardReg._InwardId, SqlDbType.BigInt);
//SqlParameter pPOId = new SqlParameter(MaterialInwardReg._POId,SqlDbType.BigInt);
SqlParameter pDeletedBy = new SqlParameter(MaterialInwardReg._UserId, SqlDbType.BigInt);
SqlParameter pDeletedDate = new SqlParameter(MaterialInwardReg._LoginDate, SqlDbType.DateTime);
pAction.Value = 3;
pInwardId.Value = Entity_MaterialInwardReg.InwardId;
//pPOId.Value = Entity_MaterialInwardReg.POId;
pDeletedBy.Value = Entity_MaterialInwardReg.UserId;
pDeletedDate.Value = Entity_MaterialInwardReg.LoginDate;
SqlParameter[] Param = new SqlParameter[] { pAction, pInwardId, pDeletedBy, pDeletedDate };
Open(CONNECTION_STRING);
BeginTransaction();
iDelete = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, MaterialInwardReg.SP_MaterialInwardReg, Param);
if (iDelete > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
strError = ex.Message;
}
finally
{
Close();
}
return(iDelete);
}
public int UpdateForAssignStatus(ref MaterialInwardReg Entity_MaterialInwardReg, out string strError)
{
int iInsert = 0;
strError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(MaterialInwardReg._Action, SqlDbType.BigInt);
SqlParameter pInwardId = new SqlParameter(MaterialInwardReg._InwardId, SqlDbType.BigInt);
pAction.Value = 16;
pInwardId.Value = Entity_MaterialInwardReg.InwardId;
SqlParameter[] Param = new SqlParameter[] { pAction, pInwardId };
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, MaterialInwardReg.SP_MaterialInwardReg, Param);
if (iInsert > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
strError = ex.Message;
}
finally
{
Close();
}
return(iInsert);
}
public int UpdateRecord(ref MaterialInwardReg Entity_Call, out string strError)
{
int iInsert = 0;
strError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(MaterialInwardReg._Action, SqlDbType.BigInt);
SqlParameter pInwardId = new SqlParameter(MaterialInwardReg._InwardId, SqlDbType.BigInt);
SqlParameter pInwardNo = new SqlParameter(MaterialInwardReg._InwardNo, SqlDbType.NVarChar);
SqlParameter pInwardDate = new SqlParameter(MaterialInwardReg._InwardDate, SqlDbType.DateTime);
SqlParameter pPOId = new SqlParameter(MaterialInwardReg._POId, SqlDbType.NVarChar);
SqlParameter pType = new SqlParameter(MaterialInwardReg._Type, SqlDbType.NVarChar);
SqlParameter pBillNo = new SqlParameter(MaterialInwardReg._BillNo, SqlDbType.NVarChar);
SqlParameter pInwardThrough = new SqlParameter(MaterialInwardReg._InwardThrough, SqlDbType.NVarChar);
SqlParameter pSuplierId = new SqlParameter(MaterialInwardReg._SuplierId, SqlDbType.BigInt);
SqlParameter pBillingAddress = new SqlParameter(MaterialInwardReg._BillingAddress, SqlDbType.NVarChar);
SqlParameter pShippingAddress = new SqlParameter(MaterialInwardReg._ShippingAddress, SqlDbType.NVarChar);
SqlParameter pSubTotal = new SqlParameter(MaterialInwardReg._SubTotal, SqlDbType.Decimal);
SqlParameter pDiscountPer = new SqlParameter(MaterialInwardReg._DiscountPer, SqlDbType.Decimal);
SqlParameter pDiscountAmt = new SqlParameter(MaterialInwardReg._DiscountAmt, SqlDbType.Decimal);
SqlParameter pVatPer = new SqlParameter(MaterialInwardReg._VatPer, SqlDbType.Decimal);
SqlParameter pVatAmt = new SqlParameter(MaterialInwardReg._VatAmt, SqlDbType.Decimal);
SqlParameter pDekhrekhPer = new SqlParameter(MaterialInwardReg._DekhrekhPer, SqlDbType.Decimal);
SqlParameter pDekhrekhAmt = new SqlParameter(MaterialInwardReg._DekhrekhAmt, SqlDbType.Decimal);
SqlParameter pHamaliPer = new SqlParameter(MaterialInwardReg._HamaliPer, SqlDbType.Decimal);
SqlParameter pHamaliAmt = new SqlParameter(MaterialInwardReg._HamaliAmt, SqlDbType.Decimal);
SqlParameter pCESSPer = new SqlParameter(MaterialInwardReg._CESSPer, SqlDbType.Decimal);
SqlParameter pCESSAmt = new SqlParameter(MaterialInwardReg._CESSAmt, SqlDbType.Decimal);
SqlParameter pFreightPer = new SqlParameter(MaterialInwardReg._FreightPer, SqlDbType.Decimal);
SqlParameter pFreightAmt = new SqlParameter(MaterialInwardReg._FreightAmt, SqlDbType.Decimal);
SqlParameter pPackingPer = new SqlParameter(MaterialInwardReg._PackingPer, SqlDbType.Decimal);
SqlParameter pPackingAmt = new SqlParameter(MaterialInwardReg._PackingAmt, SqlDbType.Decimal);
SqlParameter pPostagePer = new SqlParameter(MaterialInwardReg._PostagePer, SqlDbType.Decimal);
SqlParameter pPostageAmt = new SqlParameter(MaterialInwardReg._PostageAmt, SqlDbType.Decimal);
SqlParameter pOtherCharges = new SqlParameter(MaterialInwardReg._OtherCharges, SqlDbType.Decimal);
SqlParameter pGrandTotal = new SqlParameter(MaterialInwardReg._GrandTotal, SqlDbType.Decimal);
SqlParameter pInstruction = new SqlParameter(MaterialInwardReg._Instruction, SqlDbType.Text);
SqlParameter pUpdatedBy = new SqlParameter(MaterialInwardReg._UserId, SqlDbType.BigInt);
SqlParameter pUpdatedDate = new SqlParameter(MaterialInwardReg._LoginDate, SqlDbType.DateTime);
SqlParameter pBillDate = new SqlParameter(MaterialInwardReg._BillDate, SqlDbType.DateTime);
SqlParameter pUserInwardNo = new SqlParameter(MaterialInwardReg._UserInwardNo, SqlDbType.NVarChar);
pAction.Value = 2;
pInwardId.Value = Entity_Call.InwardId;
pInwardNo.Value = Entity_Call.InwardNo;
pInwardDate.Value = Entity_Call.InwardDate;
pPOId.Value = Entity_Call.POId;
pType.Value = Entity_Call.Type;
pBillNo.Value = Entity_Call.BillNo;
pInwardThrough.Value = Entity_Call.InwardThrough;
pSuplierId.Value = Entity_Call.SuplierId;
pBillingAddress.Value = Entity_Call.BillingAddress;
pShippingAddress.Value = Entity_Call.ShippingAddress;
pSubTotal.Value = Entity_Call.SubTotal;
pDiscountPer.Value = Entity_Call.DiscountPer;
pDiscountAmt.Value = Entity_Call.DiscountAmt;
pVatPer.Value = Entity_Call.VatPer;
pVatAmt.Value = Entity_Call.VatAmt;
pDekhrekhPer.Value = Entity_Call.DekhrekhPer;
pDekhrekhAmt.Value = Entity_Call.DekhrekhAmt;
pHamaliPer.Value = Entity_Call.HamaliPer;
pHamaliAmt.Value = Entity_Call.HamaliAmt;
pCESSPer.Value = Entity_Call.CESSPer;
pCESSAmt.Value = Entity_Call.CESSAmt;
pFreightPer.Value = Entity_Call.FreightPer;
pFreightAmt.Value = Entity_Call.FreightAmt;
pPackingPer.Value = Entity_Call.PackingPer;
pPackingAmt.Value = Entity_Call.PackingAmt;
pPostagePer.Value = Entity_Call.PostagePer;
pPostageAmt.Value = Entity_Call.PostageAmt;
pOtherCharges.Value = Entity_Call.OtherCharges;
pGrandTotal.Value = Entity_Call.GrandTotal;
pInstruction.Value = Entity_Call.Instruction;
pUpdatedBy.Value = Entity_Call.UserId;
pUpdatedDate.Value = Entity_Call.LoginDate;
pBillDate.Value = Entity_Call.BillDate;
pUserInwardNo.Value = Entity_Call.UserInwardNo;
SqlParameter[] Param = new SqlParameter[] { pAction, pInwardId, pInwardNo, pInwardDate, pPOId, pType, pBillNo, pInwardThrough, pBillingAddress, pShippingAddress,
pSubTotal, pDiscountPer, pDiscountAmt, pVatPer, pVatAmt, pDekhrekhPer, pDekhrekhAmt, pHamaliPer, pHamaliAmt,
pCESSPer, pCESSAmt, pFreightPer, pFreightAmt, pPackingPer, pPackingAmt, pPostagePer, pPostageAmt, pOtherCharges, pGrandTotal,
pInstruction, pUpdatedBy, pUpdatedDate, pSuplierId, pBillDate, pUserInwardNo };
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, MaterialInwardReg.SP_MaterialInwardReg, Param);
if (iInsert > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
strError = ex.Message;
}
finally
{
Close();
}
return(iInsert);
}
public int InsertDetailsRecord(ref MaterialInwardReg Entity_MaterialInwardReg, out string strError)
{
int iInsert = 0;
strError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter(MaterialInwardReg._Action, SqlDbType.BigInt);
SqlParameter pInwardId = new SqlParameter(MaterialInwardReg._InwardId, SqlDbType.BigInt);
SqlParameter pItemId = new SqlParameter(MaterialInwardReg._ItemId, SqlDbType.BigInt);
SqlParameter pInwardQty = new SqlParameter(MaterialInwardReg._InwardQty, SqlDbType.Decimal);
SqlParameter pOrderQty = new SqlParameter(MaterialInwardReg._OrderQty, SqlDbType.Decimal);
SqlParameter pPendingQty = new SqlParameter(MaterialInwardReg._PendingQty, SqlDbType.Decimal);
SqlParameter pInwardRate = new SqlParameter(MaterialInwardReg._InwardRate, SqlDbType.Decimal);
SqlParameter pPORate = new SqlParameter(MaterialInwardReg._PORate, SqlDbType.Decimal);
SqlParameter pDiffrence = new SqlParameter(MaterialInwardReg._Diffrence, SqlDbType.Decimal);
SqlParameter pAmount = new SqlParameter(MaterialInwardReg._Amount, SqlDbType.Decimal);
SqlParameter pTaxPer = new SqlParameter(MaterialInwardReg._TaxPer, SqlDbType.Decimal);
SqlParameter pTaxAmount = new SqlParameter(MaterialInwardReg._TaxAmount, SqlDbType.Decimal);
SqlParameter pDiscPer = new SqlParameter(MaterialInwardReg._DiscPer, SqlDbType.Decimal);
SqlParameter pDiscAmt = new SqlParameter(MaterialInwardReg._DiscAmt, SqlDbType.Decimal);
SqlParameter pNetAmount = new SqlParameter(MaterialInwardReg._NetAmount, SqlDbType.Decimal);
SqlParameter pExpectedDate = new SqlParameter(MaterialInwardReg._ExpectedDate, SqlDbType.DateTime);
SqlParameter pDeliveryDate = new SqlParameter(MaterialInwardReg._DeliveryDate, SqlDbType.DateTime);
SqlParameter pUnitId = new SqlParameter(MaterialInwardReg._UnitId, SqlDbType.BigInt);
SqlParameter pStockDate = new SqlParameter(MaterialInwardReg._StockDate, SqlDbType.DateTime);
SqlParameter pStockLocationID = new SqlParameter(MaterialInwardReg._StockLocationID, SqlDbType.BigInt);
SqlParameter pLocID = new SqlParameter(MaterialInwardReg._LocID, SqlDbType.BigInt);
SqlParameter pConversionUnitId = new SqlParameter(MaterialInwardReg._ConversionUnitId, SqlDbType.BigInt);
SqlParameter pActualQty = new SqlParameter(MaterialInwardReg._ActualQty, SqlDbType.Decimal);
SqlParameter pItemDesc = new SqlParameter(MaterialInwardReg._ItemDesc, SqlDbType.NVarChar);
pAction.Value = 8;
pInwardId.Value = Entity_MaterialInwardReg.InwardId;
pItemId.Value = Entity_MaterialInwardReg.ItemId;
pInwardQty.Value = Entity_MaterialInwardReg.InwardQty;
pOrderQty.Value = Entity_MaterialInwardReg.OrderQty;
pPendingQty.Value = Entity_MaterialInwardReg.PendingQty;
pInwardRate.Value = Entity_MaterialInwardReg.InwardRate;
pPORate.Value = Entity_MaterialInwardReg.PORate;
pDiffrence.Value = Entity_MaterialInwardReg.Diffrence;
pAmount.Value = Entity_MaterialInwardReg.Amount;
pTaxPer.Value = Entity_MaterialInwardReg.TaxPer;
pTaxAmount.Value = Entity_MaterialInwardReg.TaxAmount;
pDiscPer.Value = Entity_MaterialInwardReg.DiscPer;
pDiscAmt.Value = Entity_MaterialInwardReg.DiscAmt;
pNetAmount.Value = Entity_MaterialInwardReg.NetAmount;
pExpectedDate.Value = Entity_MaterialInwardReg.ExpectedDate;
pDeliveryDate.Value = Entity_MaterialInwardReg.DeliveryDate;
pUnitId.Value = Entity_MaterialInwardReg.UnitId;
pStockDate.Value = Entity_MaterialInwardReg.StockDate;
pStockLocationID.Value = Entity_MaterialInwardReg.StockLocationID;
pLocID.Value = Entity_MaterialInwardReg.LocID;
pConversionUnitId.Value = Entity_MaterialInwardReg.ConversionUnitId;
pActualQty.Value = Entity_MaterialInwardReg.ActualQty;
pItemDesc.Value = Entity_MaterialInwardReg.ItemDesc;
SqlParameter[] Param = new SqlParameter[] { pAction, pInwardId, pItemId, pInwardQty, pOrderQty, pPendingQty, pInwardRate, pPORate, pDiffrence, pAmount,
pTaxPer, pTaxAmount, pDiscPer, pDiscAmt, pNetAmount, pExpectedDate, pDeliveryDate, pUnitId, pStockDate, pStockLocationID, pLocID, pConversionUnitId, pActualQty
, pItemDesc };
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, MaterialInwardReg.SP_MaterialInwardReg, Param);
if (iInsert > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
strError = ex.Message;
}
finally
{
Close();
}
return(iInsert);
}
