public int InsertVendorDtls(ref GeneratePO Obj_Entity, out string StrError)
{
int iInsert = 0;
StrError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter("@Action", SqlDbType.BigInt);
SqlParameter pCentralPOId = new SqlParameter(GeneratePO._CentralPOId, SqlDbType.BigInt);
SqlParameter pVendorId = new SqlParameter(GeneratePO._VendorId, SqlDbType.BigInt);
SqlParameter pOrderQtyDist = new SqlParameter(GeneratePO._OrderQtyDist, SqlDbType.Decimal);
SqlParameter pExpectedAmt = new SqlParameter(GeneratePO._ExpectedAmt, SqlDbType.Decimal);
SqlParameter pPurchaseRate = new SqlParameter(GeneratePO._PurchaseRate, SqlDbType.Decimal);
pAction.Value = 8;
pVendorId.Value = Obj_Entity.VendorId;
pCentralPOId.Value = Obj_Entity.CentralPOId;
pOrderQtyDist.Value = Obj_Entity.OrderQtyDist;
pExpectedAmt.Value = Obj_Entity.ExpectedAmt;
pPurchaseRate.Value = Obj_Entity.PurchaseRate;
SqlParameter[] param = new SqlParameter[] { pAction, pVendorId, pCentralPOId, pOrderQtyDist, pExpectedAmt, pPurchaseRate };
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, GeneratePO.SP_GeneratePO, param);
if (iInsert > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
StrError = ex.Message;
}
finally
{
Close();
}
return(iInsert);
}
public int DeleteRecord(ref GeneratePO Obj_Entity, out string StrError)
{
int iDelete = 0;
StrError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter("@Action", SqlDbType.BigInt);
SqlParameter pCentralPOId = new SqlParameter(GeneratePO._CentralPOId, SqlDbType.BigInt);
SqlParameter pIsDeleted = new SqlParameter(GeneratePO._IsDeleted, SqlDbType.Bit);
SqlParameter pUserId = new SqlParameter(GeneratePO._UserId, SqlDbType.BigInt);
SqlParameter pLoginDate = new SqlParameter(GeneratePO._LoginDate, SqlDbType.DateTime);
pAction.Value = 3;
pCentralPOId.Value = Obj_Entity.CentralPOId;
pIsDeleted.Value = Obj_Entity.IsDeleted;
pUserId.Value = Obj_Entity.UserId;
pLoginDate.Value = Obj_Entity.LoginDate;
SqlParameter[] Param = new SqlParameter[] { pAction, pCentralPOId, pIsDeleted, pUserId, pLoginDate };
Open(CONNECTION_STRING);
BeginTransaction();
iDelete = SQLHelper.ExecuteNonQuery(_Connection, _Transaction, CommandType.StoredProcedure, GeneratePO.SP_GeneratePO, Param);
if (iDelete > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
StrError = ex.Message;
}
finally
{
Close();
}
return(iDelete);
}
public int InsertRecord(ref GeneratePO Obj_Entity, out string StrError)
{
int iInsert = 0;
StrError = string.Empty;
try
{
SqlParameter pAction = new SqlParameter("@Action", SqlDbType.BigInt);
SqlParameter pPONo = new SqlParameter(GeneratePO._CentralPONo, SqlDbType.NVarChar);
SqlParameter pPODate = new SqlParameter(GeneratePO._CentralPODate, SqlDbType.DateTime);
SqlParameter pDeptId = new SqlParameter(GeneratePO._DepartmentId, SqlDbType.BigInt);
SqlParameter pItemId = new SqlParameter(GeneratePO._ItemId, SqlDbType.BigInt);
SqlParameter pReqQty = new SqlParameter(GeneratePO._ReqQty, SqlDbType.Decimal);
SqlParameter pQtyInHand = new SqlParameter(GeneratePO._QtyInHand, SqlDbType.Decimal);
SqlParameter pMinStkLvl = new SqlParameter(GeneratePO._MinStockLevel, SqlDbType.Decimal);
SqlParameter pLocationId = new SqlParameter(GeneratePO._LocationId, SqlDbType.Decimal);
SqlParameter pTransitQty = new SqlParameter(GeneratePO._TransitQty, SqlDbType.Decimal);
SqlParameter pVendor = new SqlParameter(GeneratePO._Vendor, SqlDbType.NVarChar);
SqlParameter pQtyToOrder = new SqlParameter(GeneratePO._QtyToOrder, SqlDbType.Decimal);
SqlParameter pQtyOrder = new SqlParameter(GeneratePO._OrderQty, SqlDbType.Decimal);
SqlParameter pTotalAmount = new SqlParameter(GeneratePO._TotalAmount, SqlDbType.Decimal);
SqlParameter pUserId = new SqlParameter(GeneratePO._UserId, SqlDbType.BigInt);
SqlParameter pLoginDate = new SqlParameter(GeneratePO._LoginDate, SqlDbType.DateTime);
SqlParameter pIsDeleted = new SqlParameter(GeneratePO._IsDeleted, SqlDbType.Bit);
pAction.Value = 1;
pPONo.Value = Obj_Entity.CentralPONo;
pPODate.Value = Obj_Entity.CentralPODate;
pDeptId.Value = Obj_Entity.DepartmentId;
pItemId.Value = Obj_Entity.ItemId;
pReqQty.Value = Obj_Entity.ReqQty;
pQtyInHand.Value = Obj_Entity.QtyInHand;
pMinStkLvl.Value = Obj_Entity.MinStockLevel;
pLocationId.Value = Obj_Entity.LocationId;
pTransitQty.Value = Obj_Entity.TransitQty;
pVendor.Value = Obj_Entity.Vendor;
pQtyToOrder.Value = Obj_Entity.QtyToOrder;
pQtyOrder.Value = Obj_Entity.OrderQty;
pTotalAmount.Value = Obj_Entity.TotalAmount;
pUserId.Value = Obj_Entity.UserId;
pLoginDate.Value = Obj_Entity.LoginDate;
pIsDeleted.Value = Obj_Entity.IsDeleted;
SqlParameter[] Param = new SqlParameter[] { pAction, pPONo, pPODate, pDeptId, pItemId, pReqQty, pQtyInHand, pMinStkLvl,
pLocationId, pTransitQty, pVendor, pQtyToOrder, pQtyOrder, pTotalAmount, pUserId, pLoginDate, pIsDeleted };
Open(CONNECTION_STRING);
BeginTransaction();
iInsert = SQLHelper.ExecuteScalar(_Connection, _Transaction, CommandType.StoredProcedure, GeneratePO.SP_GeneratePO, Param);
if (iInsert > 0)
{
CommitTransaction();
}
else
{
RollBackTransaction();
}
}
catch (Exception ex)
{
RollBackTransaction();
StrError = ex.Message;
}
finally
{
Close();
}
return(iInsert);
}
