public CResult Create(CPriceMaster oPM) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_Price_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); // cmd.Parameters.AddWithValue("@Price_OId", oPM.Price_OId); cmd.Parameters.AddWithValue("@Price_Branch", oPM.Price_Branch); cmd.Parameters.AddWithValue("@Price_ItemOId", oPM.Price_ItemOId); cmd.Parameters.AddWithValue("@Price_FromDate", oPM.Price_FromDate); cmd.Parameters.AddWithValue("@Price_ToDate", oPM.Price_ToDate); cmd.Parameters.AddWithValue("@Price_Currency", oPM.Price_Currency); cmd.Parameters.AddWithValue("@Price_FactoryPrice", oPM.Price_FactoryPrice); cmd.Parameters.AddWithValue("@Price_ListPrice", oPM.Price_ListPrice); cmd.Parameters.AddWithValue("@Price_VatPercent", oPM.Price_VatPercent); cmd.Parameters.AddWithValue("@Price_VatPrice", oPM.Price_VatPrice); cmd.Parameters.AddWithValue("@Price_Disc", oPM.Price_Disc); cmd.Parameters.AddWithValue("@Price_DiscPrice", oPM.Price_DiscPrice); cmd.Parameters.AddWithValue("@Price_Creator", oPM.Creator); cmd.Parameters.AddWithValue("@Price_CreationDate", oPM.CreationDate); cmd.Parameters.AddWithValue("@Price_UpdateBy", oPM.UpdateBy); cmd.Parameters.AddWithValue("@Price_UpdateDate", oPM.UpdateDate); cmd.ExecuteNonQuery(); oConnManager.Commit(); oResult.IsSuccess = true; } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CParty oParty) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Parameters.Clear(); cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_Party_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Party_Branch", oParty.Party_Branch); cmd.Parameters.AddWithValue("@Party_Name", oParty.Party_Name); cmd.Parameters.AddWithValue("@Party_Address", oParty.Party_Address); cmd.Parameters.AddWithValue("@Party_City", oParty.Party_City); cmd.Parameters.AddWithValue("@Party_Country", oParty.Party_Country); cmd.Parameters.AddWithValue("@Party_Phone", oParty.Party_Phone); cmd.Parameters.AddWithValue("@Party_Mobile", oParty.Party_Mobile); cmd.Parameters.AddWithValue("@Party_Email", oParty.Party_Email); cmd.Parameters.AddWithValue("@Party_ContactPerson1", oParty.Party_ContactPerson1); cmd.Parameters.AddWithValue("@Party_Phone1", oParty.Party_Phone1); cmd.Parameters.AddWithValue("@Party_Contactperson2", oParty.Party_Contactperson2); cmd.Parameters.AddWithValue("@Party_Phone2", oParty.Party_Phone2); cmd.Parameters.AddWithValue("@Party_Creator", oParty.Creator); cmd.Parameters.AddWithValue("@Party_CreationDate", oParty.CreationDate); cmd.Parameters.AddWithValue("@Party_UpdateBy", oParty.UpdateBy); cmd.Parameters.AddWithValue("@Party_UpdateDate", oParty.UpdateDate); cmd.ExecuteNonQuery(); oConnManager.Commit(); oResult.IsSuccess = true; } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CPayment oPayment) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Parameters.Clear(); cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_Payment_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Payment_Branch", oPayment.Payment_Branch); cmd.Parameters.AddWithValue("@Payment_Date", oPayment.Payment_Date); cmd.Parameters.AddWithValue("@Payment_PartyOID", oPayment.Payment_PartyOID); cmd.Parameters.AddWithValue("@Payment_Amount", oPayment.Payment_Amount); cmd.Parameters.AddWithValue("@Payment_CurrencyOID", oPayment.Payment_CurrencyOID); cmd.Parameters.AddWithValue("@Payment_CurrencyRate", oPayment.Payment_CurrencyRate); cmd.Parameters.AddWithValue("@Payment_BDT", oPayment.Payment_BDT); cmd.Parameters.AddWithValue("@Payment_Media", oPayment.Payment_Media); cmd.Parameters.AddWithValue("@Payment_RecieptConfirmation", oPayment.Payment_RecieptConfirmation); cmd.Parameters.AddWithValue("@Payment_ReceivedDate", oPayment.Payment_ReceivedDate); cmd.Parameters.AddWithValue("@Payment_Creator", oPayment.Creator); cmd.Parameters.AddWithValue("@Payment_CreationDate", oPayment.CreationDate); cmd.Parameters.AddWithValue("@Payment_UpdateBy", oPayment.UpdateBy); cmd.Parameters.AddWithValue("@Payment_UpdateDate", oPayment.UpdateDate); cmd.ExecuteNonQuery(); oConnManager.Commit(); oResult.IsSuccess = true; } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CPurchase oPurchase) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Parameters.Clear(); cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_Purchase_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Purchase_Branch", oPurchase.Purchase_Branch); cmd.Parameters.AddWithValue("@Purchase_PartyOID", oPurchase.Purchase_PartyOID); cmd.Parameters.AddWithValue("@Purchase_GroupID", oPurchase.Purchase_GroupID); cmd.Parameters.AddWithValue("@Purchase_Description", oPurchase.Purchase_Description); cmd.Parameters.AddWithValue("@Purchase_Quantity", oPurchase.Purchase_Quantity); cmd.Parameters.AddWithValue("@Purchase_Amount", oPurchase.Purchase_Amount); cmd.Parameters.AddWithValue("@Purchase_CurrencyOID", oPurchase.Purchase_CurrencyOID); cmd.Parameters.AddWithValue("@Purchase_CurrencyRate", oPurchase.Purchase_CurrencyRate); cmd.Parameters.AddWithValue("@Purchase_Invoice", oPurchase.Purchase_Invoice); cmd.Parameters.AddWithValue("@Purchase_Date", oPurchase.Purchase_Date); cmd.Parameters.AddWithValue("@Purchase_Status", oPurchase.Purchase_Status); cmd.Parameters.AddWithValue("@Purchase_Creator", oPurchase.Purchase_Creator); cmd.Parameters.AddWithValue("@Purchase_CreationDate", oPurchase.Purchase_CreationDate); cmd.Parameters.AddWithValue("@Purchase_UpdateBy", oPurchase.Purchase_UpdateBy); cmd.Parameters.AddWithValue("@Purchase_UpdateDate", oPurchase.Purchase_UpdateDate); cmd.ExecuteNonQuery(); oConnManager.Commit(); oResult.IsSuccess = true; } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CUOM oUOM) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_UOM_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UOM_Code", oUOM.UOM_Code); cmd.Parameters.AddWithValue("@UOM_Name", oUOM.UOM_Name); cmd.Parameters.AddWithValue("@UOM_Branch", oUOM.UOM_Branch); cmd.Parameters.AddWithValue("@Creator", oUOM.Creator); cmd.Parameters.AddWithValue("@CreationDate", oUOM.CreationDate); cmd.Parameters.AddWithValue("@UpdateBy", oUOM.UpdateBy); cmd.Parameters.AddWithValue("@UpdateDate", oUOM.UpdateDate); cmd.Parameters.AddWithValue("@IsActive", oUOM.IsActive); cmd.Parameters.AddWithValue("@Remarks", oUOM.Remarks); cmd.ExecuteNonQuery(); oConnManager.Commit(); oResult.IsSuccess = true; } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CCurrency oCurrency) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Transaction = oConnManager.BeginTransaction(); try { StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("DECLARE @NextId NCHAR(24);"); sBuilder.Append("EXEC sp_GetNextId 'Curr_OID','Curr', @Curr_Branch, @NextId OUTPUT;"); sBuilder.Append(" Insert into t_Curr values(@NextId,@Curr_Branch,@Curr_Code,@Curr_Name)"); cmd.CommandText = sBuilder.ToString(); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Curr_Branch", oCurrency.Curr_Branch); cmd.Parameters.AddWithValue("@Curr_Code", oCurrency.Curr_Code); cmd.Parameters.AddWithValue("@Curr_Name", oCurrency.Curr_Name); cmd.ExecuteNonQuery(); oConnManager.Commit(); oResult.IsSuccess = true; } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CReorderLevel oReorderLevel) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_ReorderLevelInsert"; cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.AddWithValue("@Cust_OID", oReorderLevel.OID); cmd.Parameters.AddWithValue("@Cust_Branch", oReorderLevel.Branch_ID); cmd.Parameters.AddWithValue("@ItemID", oReorderLevel.Item_ID); cmd.Parameters.AddWithValue("@LocationID", oReorderLevel.Location_ID); cmd.Parameters.AddWithValue("@Quantity", oReorderLevel.Quantity); cmd.Parameters.AddWithValue("@Remarks", oReorderLevel.Remarks); cmd.ExecuteNonQuery(); oConnManager.Commit(); oResult.IsSuccess = true; } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult InvtIncExportBranch(List <CInventory> oInvList) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Parameters.Clear(); cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "[sp_Invt_IncExportBranch]"; cmd.CommandType = CommandType.StoredProcedure; foreach (CInventory oInventory in oInvList) { cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@Invt_OID", oInventory.Invt_OID); cmd.Parameters.AddWithValue("@Invt_Branch", oInventory.Invt_Branch); cmd.Parameters.AddWithValue("@Invt_ItemOID", oInventory.Invt_ItemOID); cmd.Parameters.AddWithValue("@Invt_QTY", oInventory.Invt_QTY); cmd.Parameters.AddWithValue("@Invt_InvType", oInventory.Invt_InvType); cmd.Parameters.AddWithValue("@Invt_BranchOID", oInventory.Invt_BranchOID); cmd.Parameters.AddWithValue("@Invt_LocOID", oInventory.Invt_LocOID); cmd.ExecuteNonQuery(); } oConnManager.Commit(); oResult.IsSuccess = true; } catch (SqlException e) { oResult.ErrMsg = e.Message; oResult.IsSuccess = false; string sRollbackError = oConnManager.Rollback(); } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CCVB oCVB) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_CVB_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CVB_Company", oCVB.Company); cmd.Parameters.AddWithValue("@CVB_Branch", oCVB.Branch); cmd.Parameters.Add("@IsSuccess", SqlDbType.Char, 1); cmd.Parameters["@IsSuccess"].Direction = ParameterDirection.ReturnValue; cmd.ExecuteNonQuery(); string st = cmd.Parameters["@IsSuccess"].Value.ToString(); oConnManager.Commit(); oResult.Data = st; oResult.IsSuccess = true; } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CUser oUser) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_UserInsert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Branch", oUser.User_Branch); cmd.Parameters.AddWithValue("@UserID", oUser.User_UserID); cmd.Parameters.AddWithValue("@UserName", oUser.User_UserName); cmd.Parameters.AddWithValue("@Passward", oUser.User_Passward); cmd.Parameters.AddWithValue("@UserType", oUser.User_UserType); cmd.Parameters.AddWithValue("@UserStatus", oUser.User_UserStatus); // cmd.Parameters.AddWithValue("@CreatedDate", oUser.User_CreatedDate); // cmd.Parameters.AddWithValue("@Phone", oUser.Phone); cmd.ExecuteNonQuery(); oConnManager.Commit(); oResult.IsSuccess = true; } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CGRMaster oMaster) { List <CInventory> oInvtList = new List <CInventory>(); oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Parameters.Clear(); cmd.Transaction = oConnManager.BeginTransaction(); try { // cmd.CommandText = "sp_GRMaster_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@GRMstr_OID", SqlDbType.Char, 24); cmd.Parameters["@GRMstr_OID"].Direction = ParameterDirection.Output; cmd.Parameters.AddWithValue("@GRMstr_Branch", oMaster.GRMstr_Branch); cmd.Parameters.AddWithValue("@GRMstr_Code", oMaster.GRMstr_Code); cmd.Parameters.AddWithValue("@GRMstr_Date", oMaster.GRMstr_Date); cmd.Parameters.AddWithValue("@GRMstr_Type", oMaster.GRMstr_Type); cmd.Parameters.AddWithValue("@GRMstr_By", oMaster.GRMstr_By); cmd.Parameters.AddWithValue("@GRMstr_RefBy", oMaster.GRMstr_RefBy); cmd.Parameters.AddWithValue("@GRMstr_VendorID", oMaster.GRMstr_VendorID); cmd.Parameters.AddWithValue("@GRMstr_TotalAmt", oMaster.GRMstr_TotalAmt); cmd.Parameters.AddWithValue("@Creator", oMaster.Creator); cmd.Parameters.AddWithValue("@CreationDate", oMaster.CreationDate); cmd.Parameters.AddWithValue("@UpdateBy", oMaster.UpdateBy); cmd.Parameters.AddWithValue("@UpdateDate", oMaster.UpdateDate); cmd.Parameters.AddWithValue("@IsActive", (oMaster.IsActive == "Y") ? 1 : 0); cmd.Parameters.AddWithValue("@Remarks", oMaster.Remarks); cmd.Parameters.AddWithValue("@IsImported", oMaster.GRMstr_IsImported); cmd.ExecuteNonQuery(); string stGRMStr_OID = cmd.Parameters["@GRMstr_OID"].Value.ToString(); if (stGRMStr_OID.Trim() == "") { oResult.ErrMsg = "This delivered data is already exists."; oResult.IsSuccess = false; return(oResult); } foreach (CGRDetails oDetails in oMaster.GRMstr_DetailsList) { cmd.CommandText = "sp_GRDetails_Insert"; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@GRDet_Branch", oDetails.GRDet_Branch); cmd.Parameters.AddWithValue("@GRDet_OID", oDetails.GRDet_OID); cmd.Parameters.AddWithValue("@GRDet_MStrOID", stGRMStr_OID); cmd.Parameters.AddWithValue("@GRDet_ItemOID", oDetails.GRDet_ItemOID); cmd.Parameters.AddWithValue("@GRDet_QTY", oDetails.GRDet_QTY); cmd.Parameters.AddWithValue("@GRDet_UOM", oDetails.GRDet_UOM); cmd.Parameters.AddWithValue("@GRDet_BranchOID", oDetails.GRDet_BranchOID); cmd.Parameters.AddWithValue("@GRDet_LocOID", oDetails.GRDet_LocOID); cmd.Parameters.AddWithValue("@GRDet_InvType", oDetails.GRDet_InvType); cmd.Parameters.AddWithValue("@GRDet_Price", oDetails.GRDet_Price); cmd.Parameters.AddWithValue("@GRDet_Currency", oDetails.GRDet_Currency); cmd.Parameters.AddWithValue("@GRDet_Amount", oDetails.GRDet_Amount); cmd.ExecuteNonQuery(); // populate inv list CInventory oInventory = new CInventory(); oInventory.Invt_Branch = oDetails.GRDet_Branch; oInventory.Invt_BranchOID = oDetails.GRDet_BranchOID; oInventory.Invt_InvType = oDetails.GRDet_InvType; oInventory.Invt_ItemOID = oDetails.GRDet_ItemOID; oInventory.Invt_LocOID = oDetails.GRDet_LocOID; oInventory.Invt_QTY = oDetails.GRDet_QTY; oInvtList.Add(oInventory); } //Update inv CInventoryBO oInventoryBO = new CInventoryBO(); oResult = oInventoryBO.InvtInc(oInvtList); if (oResult.IsSuccess) { oConnManager.Commit(); oResult.IsSuccess = true; } else { oResult.ErrMsg = oConnManager.Rollback(); oResult.IsSuccess = false; } } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CMTMaster oMTMaster) { List <CInventory> oSrcInvtList = new List <CInventory>(); List <CInventory> oDesInvtList = new List <CInventory>(); oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_MTMstr_Insert"; cmd.CommandType = CommandType.StoredProcedure; //cmd.Parameters.AddWithValue("@MTMstr_OID", oMTMaster.MTMstr_OID); SqlParameter sParam = new SqlParameter("@MTMstr_OID", SqlDbType.Char, 24); sParam.Direction = ParameterDirection.Output; cmd.Parameters.Add(sParam).Value = ""; cmd.Parameters.AddWithValue("@MTMstr_Branch", oMTMaster.MTMstr_Branch); cmd.Parameters.AddWithValue("@MTMstr_Code", oMTMaster.MTMstr_Code); cmd.Parameters.AddWithValue("@MTMstr_Date", oMTMaster.MTMstr_Date); cmd.Parameters.AddWithValue("@MTMstr_DOrder", oMTMaster.MTMstr_DOrder); cmd.Parameters.AddWithValue("@MTMstr_Creator", oMTMaster.Creator); cmd.Parameters.AddWithValue("@MTMstr_CreationDate", oMTMaster.CreationDate); cmd.Parameters.AddWithValue("@MTMstr_UpdatedBy", oMTMaster.UpdateBy); cmd.Parameters.AddWithValue("@MTMstr_UpdateDate", oMTMaster.UpdateDate); cmd.Parameters.AddWithValue("@MTMstr_IsActive", (oMTMaster.IsActive == "Y")?1:0); cmd.Parameters.AddWithValue("@MTMstr_Remarks", oMTMaster.Remarks); cmd.ExecuteNonQuery(); string stMTMstr_OID = cmd.Parameters["@MTMstr_OID"].Value.ToString(); foreach (CMTDetails oDetails in oMTMaster.MTMstr_DetailsList) { cmd.CommandText = "sp_MTDtls_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); cmd.Parameters.AddWithValue("@MTDtls_Branch", oDetails.MTDtls_Branch); cmd.Parameters.AddWithValue("@MTDtls_OID", oDetails.MTDtls_OID); cmd.Parameters.AddWithValue("@MTDtls_MstrOID", stMTMstr_OID); cmd.Parameters.AddWithValue("@MTDtls_ItemOID", oDetails.MTDtls_ItemOID); cmd.Parameters.AddWithValue("@MTDtls_IssQty", oDetails.MTDtls_IssQty); cmd.Parameters.AddWithValue("@MTDtls_IssUOMOID", oDetails.MTDtls_IssUOMOID); cmd.Parameters.AddWithValue("@MTDtls_SBranOID", oDetails.MTDtls_SBranOID); cmd.Parameters.AddWithValue("@MTDtls_SrcLocOID", oDetails.MTDtls_SrcLocOID); cmd.Parameters.AddWithValue("@MTDtls_SrcInvTyp", oDetails.MTDtls_SrcInvTyp); cmd.Parameters.AddWithValue("@MTDtls_DBranOID", oDetails.MTDtls_DBranOID); cmd.Parameters.AddWithValue("@MTDtls_DestLocOID", oDetails.MTDtls_DestLocOID); cmd.Parameters.AddWithValue("@MTDtls_DesInvtyp", oDetails.MTDtls_DesInvtyp); cmd.Parameters.AddWithValue("@MTDtls_RQty", oDetails.MTDtls_RQty); cmd.Parameters.AddWithValue("@MTDtls_RUOMOID", oDetails.MTDtls_RUOMOID); cmd.Parameters.AddWithValue("@MTDtls_Status", oDetails.MTDtls_Status); cmd.ExecuteNonQuery(); // populate inv list(decrease) CInventory oInventory = new CInventory(); oInventory.Invt_Branch = oDetails.MTDtls_Branch; oInventory.Invt_BranchOID = oDetails.MTDtls_SBranOID; oInventory.Invt_InvType = oDetails.MTDtls_SrcInvTyp; oInventory.Invt_ItemOID = oDetails.MTDtls_ItemOID; oInventory.Invt_LocOID = oDetails.MTDtls_SrcLocOID; oInventory.Invt_QTY = oDetails.MTDtls_IssQty; oSrcInvtList.Add(oInventory); // populate inv list(increase) oInventory = new CInventory(); oInventory.Invt_Branch = oDetails.MTDtls_Branch; oInventory.Invt_BranchOID = oDetails.MTDtls_DBranOID; oInventory.Invt_InvType = oDetails.MTDtls_DesInvtyp; oInventory.Invt_ItemOID = oDetails.MTDtls_ItemOID; oInventory.Invt_LocOID = oDetails.MTDtls_DestLocOID; oInventory.Invt_QTY = oDetails.MTDtls_IssQty; oDesInvtList.Add(oInventory); } //Update inv CInventoryBO oInventoryBO = new CInventoryBO(); oResult = oInventoryBO.InvtDecInc(oSrcInvtList, oDesInvtList); if (oResult.IsSuccess) { oConnManager.Commit(); oResult.IsSuccess = true; } else { oResult.ErrMsg = oConnManager.Rollback(); oResult.IsSuccess = false; } } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CEmployee oEmployee) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_EmployeeInsert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@EmpID", oEmployee.EmpID); cmd.Parameters.AddWithValue("@Name", oEmployee.Name); cmd.Parameters.AddWithValue("@FName", oEmployee.FName); cmd.Parameters.AddWithValue("@MName", oEmployee.MName); cmd.Parameters.AddWithValue("@SName", oEmployee.SName); cmd.Parameters.AddWithValue("@PerAddress", oEmployee.PerAddress); cmd.Parameters.AddWithValue("@PerDistrict", oEmployee.PerDistrict); cmd.Parameters.AddWithValue("@PreAddress", oEmployee.PreAddress); cmd.Parameters.AddWithValue("@PreDistrict", oEmployee.PreDistrict); cmd.Parameters.AddWithValue("@DOB", oEmployee.DOB); cmd.Parameters.AddWithValue("@BloodGroup", oEmployee.BloodGroup); cmd.Parameters.AddWithValue("@DOJ", oEmployee.DOJ); cmd.Parameters.AddWithValue("@PcardNo", oEmployee.PcardNo); cmd.Parameters.AddWithValue("@Sex", oEmployee.Sex); cmd.Parameters.AddWithValue("@UnitID", oEmployee.UnitID); cmd.Parameters.AddWithValue("@EmployeeType", oEmployee.EmployeeType); cmd.Parameters.AddWithValue("@FloorID", oEmployee.FloorID); cmd.Parameters.AddWithValue("@SectionID", oEmployee.SectionID); cmd.Parameters.AddWithValue("@BlockID", oEmployee.BlockID); cmd.Parameters.AddWithValue("@DesignationID", oEmployee.DesignationID); cmd.Parameters.AddWithValue("@GradeID", oEmployee.GradeID); cmd.Parameters.AddWithValue("@Basic", oEmployee.Basic); cmd.Parameters.AddWithValue("@HouseRent", oEmployee.HouseRent); cmd.Parameters.AddWithValue("@Medical", oEmployee.Medical); cmd.Parameters.AddWithValue("@Conveyance", oEmployee.Conveyance); cmd.Parameters.AddWithValue("@Shift", oEmployee.Shift); cmd.Parameters.AddWithValue("@IsAllowance", oEmployee.IsAllowance); cmd.Parameters.AddWithValue("@IsAttendanceBonus", oEmployee.IsAttendanceBonus); cmd.Parameters.AddWithValue("@IsOT", oEmployee.IsOT); cmd.Parameters.AddWithValue("@IsActive", oEmployee.IsActive); cmd.Parameters.AddWithValue("@Education", oEmployee.Education); cmd.Parameters.AddWithValue("@Remarks", oEmployee.Remarks); //cmd.Parameters.AddWithValue("@GName", oGroup.GName); //cmd.Parameters.AddWithValue("@SID", oGroup.SID); cmd.ExecuteNonQuery(); oConnManager.Commit(); oResult.IsSuccess = true; } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CSupplier oCS) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_Cust_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Clear(); // cmd.Parameters.AddWithValue("@Cust_OId", oCS.Cust_OId); cmd.Parameters.AddWithValue("@Cust_Branch", oCS.Cust_Branch); cmd.Parameters.AddWithValue("@Cust_Id", oCS.Cust_Id); cmd.Parameters.AddWithValue("@Cust_Name", oCS.Cust_Name); cmd.Parameters.AddWithValue("@Cust_CSType", oCS.Cust_CSType); cmd.Parameters.AddWithValue("@Cust_ContactP", oCS.Cust_ContactP); cmd.Parameters.AddWithValue("@Cust_Address", oCS.Cust_Address); cmd.Parameters.AddWithValue("@Cust_Cell", oCS.Cust_Cell); cmd.Parameters.AddWithValue("@Cust_Phone", oCS.Cust_Phone); cmd.Parameters.AddWithValue("@Cust_Email", oCS.Cust_Email); cmd.Parameters.AddWithValue("@Cust_Fax", oCS.Cust_Fax); cmd.Parameters.AddWithValue("@Cust_Web", oCS.Cust_Web); cmd.Parameters.AddWithValue("@Cust_IsActive", oCS.Cust_IsActive); cmd.Parameters.AddWithValue("@Cust_DiscRate", oCS.Cust_DiscRate); cmd.Parameters.AddWithValue("@Cust_Creator", oCS.Creator); cmd.Parameters.AddWithValue("@Cust_CreationDate", oCS.CreationDate); cmd.Parameters.AddWithValue("@Cust_UpdateBy", oCS.UpdateBy); cmd.Parameters.AddWithValue("@Cust_UpdateDate", oCS.UpdateDate); cmd.ExecuteNonQuery(); oConnManager.Commit(); oResult.IsSuccess = true; } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CMemberShip oMemberShip) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Transaction = oConnManager.BeginTransaction(); try { StringBuilder sBuilder = new StringBuilder(); sBuilder.Append("DECLARE @NextId NCHAR(24);"); sBuilder.Append("EXEC sp_GetNextId 'Member_OID','Member', @Member_Branch, @NextId OUTPUT;"); sBuilder.Append(" Insert into t_Member values(@NextId,@Member_Branch,"); sBuilder.Append("@Member_MembershipID,@Member_Name,@Member_Mobile,@Member_DateOfBirth,"); sBuilder.Append("@Member_FromDate,@Member_ToDate,@Member_Address,"); sBuilder.Append("@Member_Area,@Member_PostCode,@Member_Phone,@Member_Email,@Member_Occupation,@Member_FamilyMember,"); sBuilder.Append("@Member_CreatedBy,@Member_CreationDate,@Member_UpdateBy,@Member_UpdateDate,@Member_IsActive,@Member_DiscountAmount)"); cmd.CommandText = sBuilder.ToString(); cmd.CommandType = CommandType.Text; cmd.Parameters.AddWithValue("@Member_Branch", oMemberShip.Branch); cmd.Parameters.AddWithValue("@Member_MembershipID", oMemberShip.MembershipID); cmd.Parameters.AddWithValue("@Member_Name", oMemberShip.MemberName); cmd.Parameters.AddWithValue("@Member_Mobile", oMemberShip.Mobile); cmd.Parameters.AddWithValue("@Member_DateOfBirth", oMemberShip.DateOfBirth); cmd.Parameters.AddWithValue("@Member_FromDate", oMemberShip.Fromdate); cmd.Parameters.AddWithValue("@Member_ToDate", oMemberShip.Todate); cmd.Parameters.AddWithValue("@Member_Address", oMemberShip.Address); cmd.Parameters.AddWithValue("@Member_Area", oMemberShip.Area); cmd.Parameters.AddWithValue("@Member_PostCode", oMemberShip.PostCode); cmd.Parameters.AddWithValue("@Member_Phone", oMemberShip.Phone); cmd.Parameters.AddWithValue("@Member_Email", oMemberShip.Email); cmd.Parameters.AddWithValue("@Member_Occupation", oMemberShip.Occupation); cmd.Parameters.AddWithValue("@Member_FamilyMember", oMemberShip.FamilyMember); cmd.Parameters.AddWithValue("@Member_CreatedBy", oMemberShip.Creator); cmd.Parameters.AddWithValue("@Member_CreationDate", oMemberShip.CreationDate); cmd.Parameters.AddWithValue("@Member_UpdateBy", ""); cmd.Parameters.AddWithValue("@Member_UpdateDate", ""); cmd.Parameters.AddWithValue("@Member_IsActive", 1); cmd.Parameters.AddWithValue("@Member_DiscountAmount", oMemberShip.Member_DiscountAmount); cmd.ExecuteNonQuery(); oConnManager.Commit(); oResult.IsSuccess = true; } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }
public CResult Create(CCompany oCompany) { oResult = new CResult(); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.Parameters.Clear(); cmd.Transaction = oConnManager.BeginTransaction(); try { cmd.CommandText = "sp_Company_Insert"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Comp_OId", oCompany.Comp_OId); cmd.Parameters.AddWithValue("@Comp_Branch", oCompany.Comp_Branch); cmd.Parameters.AddWithValue("@Comp_Code", oCompany.Comp_Code); cmd.Parameters.AddWithValue("@Comp_Name", oCompany.Comp_Name); cmd.Parameters.AddWithValue("@Comp_FullName", oCompany.Comp_FullName); cmd.Parameters.AddWithValue("@Comp_Street", oCompany.Comp_Street); cmd.Parameters.AddWithValue("@Comp_Road", oCompany.Comp_Road); cmd.Parameters.AddWithValue("@Comp_City", oCompany.Comp_City); cmd.Parameters.AddWithValue("@Comp_Country", oCompany.Comp_Country); cmd.Parameters.AddWithValue("@Comp_Phone", oCompany.Comp_Phone); cmd.Parameters.AddWithValue("@Comp_Mobile", oCompany.Comp_Mobile); cmd.Parameters.AddWithValue("@Comp_Email", oCompany.Comp_Email); cmd.Parameters.AddWithValue("@Comp_Web", oCompany.Comp_Web); cmd.Parameters.AddWithValue("@Comp_PostalCode", oCompany.Comp_PostalCode); cmd.Parameters.AddWithValue("@Comp_Creator", oCompany.Creator); cmd.Parameters.AddWithValue("@Comp_CreationDate", oCompany.CreationDate); cmd.Parameters.AddWithValue("@Comp_UpdateBy", oCompany.UpdateBy); cmd.Parameters.AddWithValue("@Comp_UpdateDate", oCompany.UpdateDate); cmd.Parameters.AddWithValue("@Comp_IsActive", oCompany.IsActive); cmd.ExecuteNonQuery(); oConnManager.Commit(); oResult.IsSuccess = true; } catch (SqlException e) { string sRollbackError = oConnManager.Rollback(); oResult.IsSuccess = false; oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError; } finally { oConnManager.Close(); } } else { oResult.IsSuccess = false; oResult.ErrMsg = s_DBError; } return(oResult); }