public CSalesproduct DeleteFromMaster(string SOMaster_OID, string uID) { CSalesproduct oSaleaProduct = new CSalesproduct(); DataTable oDt = null; try { strSQL = "delete from t_SODet where SODet_MStrOID = '" + SOMaster_OID + "'"; oManager = new CConManager(); oDt = oManager.Read(strSQL); strSQL = string.Empty; strSQL = "delete from t_SOMstr where SOMstr_OID = '" + SOMaster_OID + "'"; oManager = new CConManager(); oDt = oManager.Read(strSQL); //strSQL = "Update t_SOMstr set SOMstr_OID='" + + "'"; } catch (Exception ex) { CConManager oManager = new CConManager(); oManager.s_ErrorMessage = ex.Message; } return(oSaleaProduct); }
public List <CSalesproduct> allselsproduct(string uID) { List <CSalesproduct> salesproductList = new List <CSalesproduct>(); DataTable oDt = null; try { strSQL = string.Format("SELECT SOMstr_OID, SOMstr_Branch, SOMstr_Code, SOMstr_Date,SOMstr_TotalAmt,SOMstr_NetAmt FROM dbo.t_SOMstr "); oManager = new CConManager(); oDt = oManager.Read(strSQL); if (oDt != null) { foreach (DataRow dr in oDt.Rows) { CSalesproduct osalesproduct = new CSalesproduct(); osalesproduct.SOMstr_OID = dr["SOMstr_OID"].ToString(); osalesproduct.SOMstr_Branch = dr["SOMstr_Branch"].ToString(); osalesproduct.SOMstr_Code = dr["SOMstr_Code"].ToString(); osalesproduct.SOMstr_Date = DateTime.Parse(dr["SOMstr_Date"].ToString()); osalesproduct.SOMstr_TotalAmt = float.Parse(dr["SOMstr_TotalAmt"].ToString()); osalesproduct.SOMstr_NetAmt = float.Parse(dr["SOMstr_NetAmt"].ToString()); salesproductList.Add(osalesproduct); osalesproduct = null; } } } catch (Exception ex) { CConManager oManager = new CConManager(); oManager.s_ErrorMessage = ex.Message; } return(salesproductList); }
private void button1_Click(object sender, EventArgs e) { SqlConnection conn = null; CConManager oConnManager = new CConManager(); string s_DBError = ""; string Item_OID = ""; string ItemCode = txtStartCode.Text; int st = Convert.ToInt32(txtStart.Text); int en = Convert.ToInt32(txtend.Text); conn = oConnManager.GetConnection(out s_DBError); if (conn != null) { for (; st <= en; st++) { string strItemCode = ItemCode.Substring(0, 4); string strCode = "" + Convert.ToString(Convert.ToInt32(ItemCode.Substring(4)) + 1); for (int j = 5; j > (strCode.Length); j--) { strItemCode += "0"; } ItemCode = strItemCode + strCode; for (int j = 10; j > (st.ToString().Length); j--) { Item_OID += "0"; } Item_OID += st.ToString(); string sql = "UPDATE t_Item SET Item_Code = '" + ItemCode + "' WHERE Item_OID='ItemXXXXBRN01 " + Item_OID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.CommandType = CommandType.Text; cmd.ExecuteNonQuery(); } catch (SqlException ewe) { } Item_OID = ""; } } oConnManager.Close(); txtStartCode.Text = ItemCode; }
public CSGoodsReceive DeleteGoodsReceivede(string Rec_OID, string Rec_ProductID, string uID) { CSGoodsReceive oReceiveDetails = new CSGoodsReceive(); DataTable oDt = null; try { strSQL = "delete from t_GReceive where Rec_OID = '" + Rec_OID + "' and Rec_ProductID = '" + Rec_ProductID + "' "; oManager = new CConManager(); oDt = oManager.Read(strSQL); } catch (Exception ex) { CConManager oManager = new CConManager(); oManager.s_ErrorMessage = ex.Message; } return(oReceiveDetails); }
//public List<CGoodsReceiveDetails> AllGoodsReceive(string Rec_OID, string uID) //{ // List<CGoodsReceiveDetails> oGoodReceiveList = new List<CGoodsReceiveDetails>(); // DataTable oDt = null; // try // { // strSQL = @"select * from t_GRDet where GRDet_MStrOID= '" + GRMstr_ID + "'"; // oManager = new CConManager(); // oDt = oManager.Read(strSQL, uID); // if (oDt.Rows.Count > 0) // { // foreach (DataRow dr in oDt.Rows) // { // CGoodsReceiveDetails oGoodsReceiveDetails = new CGoodsReceiveDetails(); // oGoodsReceiveDetails.GRDet_OID = dr["GRDet_OID"].ToString(); // oGoodsReceiveDetails.GRDet_Branch = dr["GRDet_Branch"].ToString(); // oGoodsReceiveDetails.GRDet_MStrOID = dr["GRDet_MStrOID"].ToString(); // oGoodsReceiveDetails.GRDet_ItemOID = dr["GRDet_ItemOID"].ToString(); // oGoodsReceiveDetails.GRDet_QTY = float.Parse(dr["GRDet_QTY"].ToString()); // oGoodsReceiveDetails.GRDet_UOM = dr["GRDet_UOM"].ToString(); // oGoodsReceiveDetails.GRDet_BranchOID =dr["GRDet_BranchOID"].ToString(); // oGoodsReceiveDetails.GRDet_LocOID = dr["GRDet_LocOID"].ToString(); // oGoodsReceiveDetails.GRDet_InvType = int.Parse(dr["GRDet_InvType"].ToString()); // oGoodsReceiveDetails.GRDet_Currency = dr["GRDet_Currency"].ToString(); // oGoodsReceiveDetails.GRDet_Price = float.Parse(dr["GRDet_Price"].ToString()); // oGoodsReceiveDetails.GRDet_Amount = float.Parse(dr["GRDet_Amount"].ToString()); // oGoodReceiveList.Add(oGoodsReceiveDetails); // oGoodsReceiveDetails = null; // } // } // else // { // strSQL = @"delete from t_GRMstr where GRMstr_OID = '" + GRMstr_ID + "'"; // oManager = new CConManager(); // oDt = oManager.Read(strSQL, uID); // } // } // catch (Exception ex) // { // CConManager oManager = new CConManager(); // oManager.s_ErrorMessage = ex.Message; // } // return oGoodReceiveList; //} #endregion #region Delete GoodsReceive Details public CSGoodsReceive UpdateGoodsReceivede(CSGoodsReceive ogoodreceive, string uID) { CSGoodsReceive oReceiveDetails = new CSGoodsReceive(); DataTable oDt = null; try { strSQL = "Update t_GReceive set Rec_ReceivedQty= " + ogoodreceive.Rec_ReceivedQty + "where Rec_OID = " + ogoodreceive.Rec_OID + " and Rec_ProductID = '" + ogoodreceive.Rec_ProductID + "' "; oManager = new CConManager(); oDt = oManager.Read(strSQL); } catch (Exception ex) { CConManager oManager = new CConManager(); oManager.s_ErrorMessage = ex.Message; } return(oReceiveDetails); }
public List <CSGoodsReceive> allGoodsReceive(string uID) { List <CSGoodsReceive> oGoodsReceiveList = new List <CSGoodsReceive>(); DataTable oDt = null; try { strSQL = string.Format("SELECT dbo.t_GReceive.Rec_OID, dbo.t_GReceive.Rec_ReqID, dbo.t_GReceive.Rec_IssueID, dbo.t_GReceive.Rec_BranchID, dbo.t_GReceive.Rec_ProductID, dbo.t_GReceive.Rec_WantedQTY, dbo.t_GReceive.Rec_IssueQTY, dbo.t_GReceive.Rec_Remark, dbo.t_GReceive.Rec_ReceivedQty, dbo.t_Item.Item_ItemName FROM dbo.t_Item RIGHT OUTER JOIN dbo.t_GReceive ON dbo.t_Item.Item_OID = dbo.t_GReceive.Rec_ProductID"); oManager = new CConManager(); oDt = oManager.Read(strSQL); if (oDt != null) { foreach (DataRow dr in oDt.Rows) { CSGoodsReceive oGoodReceives = new CSGoodsReceive(); oGoodReceives.Item_Name = dr["Item_ItemName"].ToString(); oGoodReceives.Rec_OID = dr["Rec_OID"].ToString(); oGoodReceives.Rec_ReqID = dr["Rec_ReqID"].ToString(); oGoodReceives.Rec_IssueID = dr["Rec_IssueID"].ToString(); oGoodReceives.Rec_BranchID = dr["Rec_BranchID"].ToString(); oGoodReceives.Rec_ProductID = dr["Rec_ProductID"].ToString(); oGoodReceives.Rec_WantedQTY = Int32.Parse(dr["Rec_WantedQTY"].ToString()); oGoodReceives.Rec_IssueQTY = Int32.Parse(dr["Rec_IssueQTY"].ToString()); oGoodReceives.Rec_Remark = dr["Rec_Remark"].ToString(); oGoodReceives.Rec_ReceivedQty = Int32.Parse(dr["Rec_ReceivedQty"].ToString()); oGoodsReceiveList.Add(oGoodReceives); oGoodReceives = null; } } } catch (Exception ex) { CConManager oManager = new CConManager(); oManager.s_ErrorMessage = ex.Message; } return(oGoodsReceiveList); }
//public List<CHijibi> amount(string uID) //{ // List<CHijibi> oamount =new List<CHijibi>(); // DataTable oDt = null; // strSQL = "select * from t_Mozila"; // oManager = new CConManager(); // oDt = oManager.Read(strSQL, uID); // if (oDt != null) // { // foreach (DataRow dr in oDt.Rows) // { // CHijibi oamounta = new CHijibi(); // oamounta.Chrom = float.Parse(dr["Chrom"].ToString()); // oamount.Add(oamounta); // oamounta = null; // } // } // return oamount; //} //public CSalesproduct CreateMaxID(string uID) //{ // string MasterID = string.Empty; // DataTable oDt = null; // try // { // strSQL = string.Format("SELECT SOMstr_OID FROM t_SOMstr "); // oManager = new CConManager(); // oDt = oManager.Read(strSQL, uID); // if (oDt != null) // { // if (oDt.Rows.Count == 0)//BIL-NO-00001 // { // MasterID = "SOMstrXXBRN01 0000000001"; // } // else // { // DataRow dr = oDt.Rows[0]; // MasterID = dr["Bill_Id"].ToString(); // MasterID = MasterID.Remove(0, 13); // MasterID = (Convert.ToInt64(MasterID) + 1).ToString(); // MasterID = MasterID.PadLeft(2, '0'); // MasterID = MasterID.PadLeft(3, '0'); // MasterID = MasterID.PadLeft(4, '0'); // MasterID = MasterID.PadLeft(5, '0'); // MasterID = MasterID.PadLeft(6, '0'); // MasterID = MasterID.PadLeft(7, 'O'); // MasterID = MasterID.PadLeft(8, '0'); // MasterID = MasterID.PadLeft(9, '0'); // MasterID = MasterID.PadLeft(10, '0'); // MasterID = MasterID.PadLeft(11, ' '); // MasterID = MasterID.PadLeft(12, '1'); // MasterID = MasterID.PadLeft(13, '0'); // MasterID = MasterID.PadLeft(14, 'N'); // MasterID = MasterID.PadLeft(15, 'R'); // MasterID = MasterID.PadLeft(16, 'B'); // MasterID = MasterID.PadLeft(17, 'X'); // MasterID = MasterID.PadLeft(18, 'X'); // MasterID = MasterID.PadLeft(19, 'r'); // MasterID = MasterID.PadLeft(20, 't'); // MasterID = MasterID.PadLeft(21, 's'); // MasterID = MasterID.PadLeft(22, 'M'); // MasterID = MasterID.PadLeft(23, 'O'); // MasterID = MasterID.PadLeft(23, 'S'); // } // } // } // catch (Exception ex) // { // oManager.s_ErrorMessage = ex.Message; // MasterID = string.Empty; // } // finally // { // oManager = null; // strSQL = string.Empty; // } // return null; //} public CSalesDetials DeleteFromdetails(string ItemID, string So_detailsID, float qty, string receiveID, string MasterID, float detamount, string uID) { CSalesDetials oSaleaDetails = new CSalesDetials(); DataTable oDt = null; try { strSQL = "delete from t_SODet where SODet_OID='" + So_detailsID + "'"; //strSQL = @"IF(EXISTS(SELECT ID FROM t_SODet WHERE SODet_ItemOID='" + Rec_OID + "'))BEGIN UPDATE t_GReceive SET Rec_ReceivedQty=Rec_ReceivedQty-" + oSaleaDetails.SODet_QTY + "where Rec_ProductID='" + Rec_OID + "' END"; //sqlList.Add(strSQL); oManager = new CConManager(); oDt = oManager.Read(strSQL); strSQL = string.Empty; strSQL = "Update t_GReceive set Rec_ReceivedQty=Rec_ReceivedQty- " + qty + " where Rec_OID='" + receiveID + "' and Rec_ProductID = '" + ItemID + "'"; oManager = new CConManager(); oDt = oManager.Read(strSQL); strSQL = string.Empty; strSQL = "Update t_SOMstr set SOMstr_NetAmt=SOMstr_NetAmt- " + detamount + " where SOMstr_OID='" + MasterID + "'"; oManager = new CConManager(); oDt = oManager.Read(strSQL); //float deletedAmount = Actualamount - amount; // float percentage = (deletedAmount * 100) / Actualamount; } catch (Exception ex) { CConManager oManager = new CConManager(); oManager.s_ErrorMessage = ex.Message; } return(oSaleaDetails); }
public CSizeBO() { oConnManager = new CConManager(); }
public CCustomerBO() { oConnManager = new CConManager(); }
public CPurchaseBO() { oConnManager = new CConManager(); }
public CCompanyBO() { oConnManager = new CConManager(); }
public CCashCardBO() { oConnManager = new CConManager(); }
public CPriceMasterBO() { oConnManager = new CConManager(); }
public CUOMBO() { oConnManager = new CConManager(); }
private void btnImport_Click(object sender, EventArgs e) { try { progressBarImport.Value = 0; Cursor = Cursors.WaitCursor; string selectGRFromHomeMaster = "select *from t_GRMstr where GRMatr_IsImported=0"; SqlConnection oConnectionForHomeDB = new CConManager().GetConnectionForRemote(); DataTable dtHome = new DataTable(); SqlCommand oCommandForHome = new SqlCommand(selectGRFromHomeMaster, oConnectionForHomeDB); oCommandForHome.CommandType = CommandType.Text; SqlDataAdapter oSqlAdapter = new SqlDataAdapter(oCommandForHome); oSqlAdapter.Fill(dtHome); List <CGRMaster> oGRMasterList = new List <CGRMaster>(); progressBarImport.Value = 70; if (dtHome.Rows.Count > 0) { progressBarImport.Value = 70; foreach (DataRow dr in dtHome.Rows) { CGRMaster oGRMaster = new CGRMaster(); oGRMaster.GRMstr_OID = ""; oGRMaster.GRMstr_Branch = currentBranch.CompBrn_Code; oGRMaster.GRMstr_Code = GetGRmstrCode(); oGRMaster.GRMstr_Type = int.Parse(dr["GRMstr_Type"].ToString()); oGRMaster.GRMstr_Date = DateTime.Parse(dr["GRMstr_Date"].ToString()); oGRMaster.GRMstr_By = dr["GRMstr_By"].ToString(); oGRMaster.Remarks = dr["GRMstr_Remarks"].ToString(); oGRMaster.GRMstr_RefBy = dr["GRMstr_RefBy"].ToString(); oGRMaster.Creator = dr["GRMstr_Creator"].ToString(); oGRMaster.CreationDate = DateTime.Parse(dr["GRMstr_CreationDate"].ToString()); oGRMaster.UpdateBy = dr["GRMstr_UpdateBy"].ToString(); oGRMaster.UpdateDate = DateTime.Parse(dr["GRMstr_UpdateDate"].ToString()); oGRMaster.IsActive = "Y"; oGRMaster.GRMstr_IsImported = 1; string selectGRForHomeDetail = "select *from t_GRDet where GRDet_MStrOID='" + dr["GRMstr_OID"].ToString() + "'"; SqlConnection oConnectionForHomeDBDetail = new CConManager().GetConnectionForRemote(); DataTable dtHomedetail = new DataTable(); SqlCommand oCommand = new SqlCommand(selectGRForHomeDetail, oConnectionForHomeDBDetail); oCommand.CommandType = CommandType.Text; SqlDataAdapter oDataAdapter = new SqlDataAdapter(oCommand); oDataAdapter.Fill(dtHomedetail); //List<CGRDetails> oGRDetailList = new List<CGRDetails>(); if (dtHomedetail.Rows.Count > 0) { foreach (DataRow drDetail in dtHomedetail.Rows) { CGRDetails oGRDetails = new CGRDetails(); oGRDetails.GRDet_Branch = currentBranch.CompBrn_Code; oGRDetails.GRDet_ItemOID = drDetail["GRDet_ItemOID"].ToString(); oGRDetails.GRDet_QTY = float.Parse(drDetail["GRDet_QTY"].ToString()); oGRDetails.GRDet_UOM = drDetail["GRDet_UOM"].ToString(); oGRDetails.GRDet_BranchOID = currentBranch.CompBrn_OId; oGRDetails.GRDet_LocOID = drDetail["GRDet_LocOID"].ToString(); oGRDetails.GRDet_InvType = int.Parse(drDetail["GRDet_InvType"].ToString()); oGRDetails.GRDet_Price = float.Parse(drDetail["GRDet_Price"].ToString()); oGRDetails.GRDet_Currency = drDetail["GRDet_Currency"].ToString(); oGRDetails.GRDet_Amount = float.Parse(drDetail["GRDet_Amount"].ToString()); //oGRDetailList.Add(oGRDetails); oGRMaster.GRMstr_DetailsList.Add(oGRDetails); } } //oGRMaster.GRMstr_DetailsList = oGRDetailList; oGRMasterList.Add(oGRMaster); } if (oGRMasterList.Count > 0) { foreach (CGRMaster oGRMaster in oGRMasterList) { progressBarImport.Value = 50; CResult oResult = new CResult(); CGRBO oGRBO = new CGRBO(); if (oGRMaster != null) { oResult = oGRBO.Create(oGRMaster); } if (oResult.IsSuccess) { progressBarImport.Value = 100; this.Cursor = Cursors.Default; oResult = oGRBO.UpdateHomeGRTable(); } progressBarImport.Value = 100; MessageBox.Show("Goods are successfully Imported", "ETLPOS", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } else if (dtHome.Rows.Count <= 0) { DialogResult oDR = MessageBox.Show("You Have No Goods For Import", "ETLPOS", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (oDR.ToString() == "OK") { this.Cursor = Cursors.Default; progressBarImport.Value = 0; } } } catch { MessageBox.Show("You Have No Goods For Import", "ETLPOS", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public CInventoryBO() { oConnManager = new CConManager(); }
public CUserBO() { oConnManager = new CConManager(); }
public CMemberShipBO() { oConnManager = new CConManager(); }
public CCurrencyBO() { oConnManager = new CConManager(); }
public CLocBO() { oConnManager = new CConManager(); }
public CReorderLevelBO() { oConnManager = new CConManager(); }
public CPaymentBO() { oConnManager = new CConManager(); }
public CMaterialTransferBO() { oConnManager = new CConManager(); }
public CSupplierBO() { oConnManager = new CConManager(); }
public CPartyBO() { oConnManager = new CConManager(); }
public CEmployeeBO() { oConnManager = new CConManager(); }
public CCommonBO() { oConnManager = new CConManager(); }
public List <CSalesDetials> Saleadetels(string SODet_MStrOID, string uID) { List <CSalesDetials> oSalesDetails = new List <CSalesDetials>(); DataTable oDt = null; try { //SELECT dbo.t_Item.Item_ItemName, dbo.t_SODet.* FROM dbo.t_Item LEFT OUTER JOIN dbo.t_SODet ON dbo.t_Item.Item_OID = dbo.t_SODet.SODet_ItemOID strSQL = @"SELECT dbo.t_SODet.SODet_OID, dbo.t_SODet.SODet_Branch, dbo.t_SODet.SODet_MStrOID, dbo.t_SODet.SODet_ItemSLNum, dbo.t_SODet.SODet_ItemOID, dbo.t_SODet.SODet_QTY, dbo.t_SODet.SODet_UOM, dbo.t_SODet.SODet_Price, dbo.t_SODet.SODet_Currency, dbo.t_SODet.SODet_Amount, dbo.t_SODet.SODet_SDValue, dbo.t_SODet.SODet_SDAmount, dbo.t_SODet.SODet_VATValue, dbo.t_SODet.SODet_VATAmount, dbo.t_SODet.SODet_Discount, dbo.t_SODet.SODet_NetAmount, dbo.t_SODet.SODet_BranchOID, dbo.t_SODet.SODet_LocOID, dbo.t_GReceive.Rec_ReceivedQty, dbo.t_GReceive.Rec_IssueQTY, dbo.t_GReceive.Rec_WantedQTY, dbo.t_GReceive.Rec_ProductID, dbo.t_GReceive.Rec_OID, dbo.t_GReceive.Rec_BranchID, dbo.t_Item.Item_ItemName FROM dbo.t_Item LEFT OUTER JOIN dbo.t_SODet ON dbo.t_Item.Item_OID = dbo.t_SODet.SODet_ItemOID LEFT OUTER JOIN dbo.t_GReceive ON dbo.t_SODet.SODet_ItemOID = dbo.t_GReceive.Rec_ProductID where SODet_MStrOID= '" + SODet_MStrOID + "'"; oManager = new CConManager(); oDt = oManager.Read(strSQL); if (oDt.Rows.Count > 0) { foreach (DataRow dr in oDt.Rows) { CSalesDetials salesDetails = new CSalesDetials(); salesDetails.SODet_OID = dr["SODet_OID"].ToString(); salesDetails.SODet_MStrOID = dr["SODet_MStrOID"].ToString(); salesDetails.SODet_ItemName = dr["Item_ItemName"].ToString(); salesDetails.SODet_Branch = dr["SODet_Branch"].ToString(); //salesDetails.SODet_ItemSLNum = dr["SODet_ItemSLNum"].ToString(); salesDetails.SODet_ItemOID = dr["SODet_ItemOID"].ToString(); //salesDetails.SODet_ItemName = dr["SODet_ItemName"].ToString(); salesDetails.SODet_QTY = float.Parse(dr["SODet_QTY"].ToString()); //salesDetails.SODet_UOM = dr["SODet_UOM"].ToString(); salesDetails.SODet_Price = float.Parse(dr["SODet_Price"].ToString()); //salesDetails.SODet_Currency = dr["SODet_Currency"].ToString(); salesDetails.SODet_Amount = float.Parse(dr["SODet_Amount"].ToString()); salesDetails.SODet_SDValue = float.Parse(dr["SODet_SDValue"].ToString()); salesDetails.SODet_SDAmount = float.Parse(dr["SODet_SDAmount"].ToString()); salesDetails.SODet_VATValue = float.Parse(dr["SODet_VATValue"].ToString()); salesDetails.SODet_VATAmount = float.Parse(dr["SODet_VATAmount"].ToString()); salesDetails.SODet_Discount = float.Parse(dr["SODet_Discount"].ToString()); salesDetails.SODet_NetAmount = float.Parse(dr["SODet_NetAmount"].ToString()); salesDetails.Rec_OID = dr["Rec_OID"].ToString(); //salesDetails.SODet_LocOID = dr["SODet_LocOID"].ToString(); oSalesDetails.Add(salesDetails); salesDetails = null; } } //else //{ // strSQL = @"delete from t_SOMstr where SOMstr_OID = '" + SODet_MStrOID + "'"; // oManager = new CConManager(); // oDt = oManager.Read(strSQL, uID); //} } catch (Exception ex) { CConManager oManager = new CConManager(); oManager.s_ErrorMessage = ex.Message; } return(oSalesDetails); }
public CGRBO() { oConnManager = new CConManager(); }
public CCVBBO() { oConnManager = new CConManager(); }