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); }