public string GetSupplier(int Sysid, out DataType.SupplierDataType _ExistData,bool IsLocal) { DataService Mycommon = new DataService(IsLocal); _ExistData = new DataType.SupplierDataType(); MySqlCommand oSqlCommand = new MySqlCommand(); string sqlQuery = "Select " + "Sysid," + "Customer," + "Address1," + "Address2," + "Address3," + "TPN," + "Mobile," + "Fax," + "Email," + "CreditLimit," + "CurrentCredit," + "VatRegNumber," + "Status," + "LastAccUser," + "LastAccDate," + "ContactPerson," + "ContactTPnumber," + "PaymentTerms," + "CreditPeriod," + "DeleveryMethod," + "Shippingadd1," + "ShippingAdd2," + "ShippingAdd3," + "Country," + "CusID," + "FFName," + "FFAccountNo," + "UnderG4," + "Email_OrderAcn," + "Email_Invoice," + "Email_Complain," + "NeedCustomerLogo," + "CurrenyCode" + " from tblsupplier" + " Where 1=1 " + " and Sysid=@Sysid"; oSqlCommand.Parameters.AddWithValue("@Sysid", Sysid); DataRow r = Mycommon.GetDataRow(sqlQuery, oSqlCommand, null, "Get Exist data Supplier"); if (r != null) { try { bool resp = false; int inSysid = 0; resp = int.TryParse(r["Sysid"].ToString(), out inSysid); _ExistData.Sysid = inSysid; _ExistData.Customer = r["Customer"].ToString(); _ExistData.Address1 = r["Address1"].ToString(); _ExistData.Address2 = r["Address2"].ToString(); _ExistData.Address3 = r["Address3"].ToString(); _ExistData.TPN = r["TPN"].ToString(); _ExistData.Mobile = r["Mobile"].ToString(); _ExistData.Fax = r["Fax"].ToString(); _ExistData.Email = r["Email"].ToString(); decimal deCreditLimit = 0; resp = decimal.TryParse(r["CreditLimit"].ToString(), out deCreditLimit); _ExistData.CreditLimit = deCreditLimit; decimal deCurrentCredit = 0; resp = decimal.TryParse(r["CurrentCredit"].ToString(), out deCurrentCredit); _ExistData.CurrentCredit = deCurrentCredit; _ExistData.VatRegNumber = r["VatRegNumber"].ToString(); int inStatus = 0; resp = int.TryParse(r["Status"].ToString(), out inStatus); _ExistData.Status = inStatus; _ExistData.LastAccUser = r["LastAccUser"].ToString(); DateTime dtLastAccDate = new DateTime(1900, 1, 1); resp = DateTime.TryParse(r["LastAccDate"].ToString(), out dtLastAccDate); if (resp) _ExistData.LastAccDate = dtLastAccDate; else _ExistData.LastAccDate = new DateTime(1900, 1, 1); _ExistData.ContactPerson = r["ContactPerson"].ToString(); _ExistData.ContactTPnumber = r["ContactTPnumber"].ToString(); _ExistData.PaymentTerms = r["PaymentTerms"].ToString(); int inCreditPeriod = 0; resp = int.TryParse(r["CreditPeriod"].ToString(), out inCreditPeriod); _ExistData.CreditPeriod = inCreditPeriod; _ExistData.DeleveryMethod = r["DeleveryMethod"].ToString(); _ExistData.Shippingadd1 = r["Shippingadd1"].ToString(); _ExistData.ShippingAdd2 = r["ShippingAdd2"].ToString(); _ExistData.ShippingAdd3 = r["ShippingAdd3"].ToString(); _ExistData.Country = r["Country"].ToString(); _ExistData.CusID = r["CusID"].ToString(); _ExistData.FFName = r["FFName"].ToString(); _ExistData.FFAccountNo = r["FFAccountNo"].ToString(); int inUnderG4 = 0; resp = int.TryParse(r["UnderG4"].ToString(), out inUnderG4); _ExistData.UnderG4 = inUnderG4; _ExistData.Email_OrderAcn = r["Email_OrderAcn"].ToString(); _ExistData.Email_Invoice = r["Email_Invoice"].ToString(); _ExistData.Email_Complain = r["Email_Complain"].ToString(); int inNeedCustomerLogo = 0; resp = int.TryParse(r["NeedCustomerLogo"].ToString(), out inNeedCustomerLogo); _ExistData.NeedCustomerLogo = inNeedCustomerLogo; _ExistData.CurrenyCode = r["CurrenyCode"].ToString(); return "True"; } catch (Exception ex) { return ex.Message; } } else return "data not found "; }