public M_SalesMan Selectm_SalesMan(M_SalesMan objm_SalesMan) { try { strquery = @"select * from M_SalesMan where SalesmanID = '" + objm_SalesMan.SalesmanID + "'"; DataRow drType = u_DBConnection.ReturnDataRow(strquery); if (drType != null) { objm_SalesMan.SalesmanID = drType["SalesmanID"].ToString(); objm_SalesMan.Compcode = drType["Compcode"].ToString(); objm_SalesMan.Locacode = drType["Locacode"].ToString(); objm_SalesMan.SalesmanName = drType["SalesmanName"].ToString(); objm_SalesMan.TP = drType["TP"].ToString(); objm_SalesMan.Fax = drType["Fax"].ToString(); objm_SalesMan.Email = drType["Email"].ToString(); objm_SalesMan.Address1 = drType["Address1"].ToString(); objm_SalesMan.Address2 = drType["Address2"].ToString(); objm_SalesMan.Address3 = drType["Address3"].ToString(); objm_SalesMan.ContactPerson = drType["ContactPerson"].ToString(); objm_SalesMan.ContactPersonNo = drType["ContactPersonNo"].ToString(); objm_SalesMan.CurrentStatus = drType["CurrentStatus"].ToString(); objm_SalesMan.Gradex = drType["Gradex"].ToString(); objm_SalesMan.NICNo = drType["NICNo"].ToString(); return(objm_SalesMan); } return(null); } catch (Exception ex) { throw ex; } }
public static string FindExisitingSalesman(string suppcode) { string str = ""; if (M_SalesManDL.ExistingM_SalesMan(suppcode.Trim())) { M_SalesMan cat = new M_SalesMan(); cat.SalesmanID = suppcode.Trim(); M_SalesManDL dl = new M_SalesManDL(); cat = dl.Selectm_SalesMan(cat); str = cat.SalesmanName; } else { str = "<Error!!!>"; } return(str); }
/// <summary> /// Saves a record to the M_SalesMan table. /// </summary> public Boolean SaveM_SalesManSP(M_SalesMan m_SalesMan, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "M_SalesManSave"; scom.Parameters.Add("@SalesmanID", SqlDbType.VarChar, 20).Value = m_SalesMan.SalesmanID; scom.Parameters.Add("@Compcode", SqlDbType.VarChar, 20).Value = m_SalesMan.Compcode; scom.Parameters.Add("@Locacode", SqlDbType.VarChar, 20).Value = m_SalesMan.Locacode; scom.Parameters.Add("@SalesmanName", SqlDbType.VarChar, 50).Value = m_SalesMan.SalesmanName; scom.Parameters.Add("@TP", SqlDbType.VarChar, 20).Value = m_SalesMan.TP; scom.Parameters.Add("@Fax", SqlDbType.VarChar, 20).Value = m_SalesMan.Fax; scom.Parameters.Add("@Email", SqlDbType.VarChar, 50).Value = m_SalesMan.Email; scom.Parameters.Add("@Address1", SqlDbType.VarChar, 50).Value = m_SalesMan.Address1; scom.Parameters.Add("@Address2", SqlDbType.VarChar, 50).Value = m_SalesMan.Address2; scom.Parameters.Add("@Address3", SqlDbType.VarChar, 50).Value = m_SalesMan.Address3; scom.Parameters.Add("@ContactPerson", SqlDbType.VarChar, 20).Value = m_SalesMan.ContactPerson; scom.Parameters.Add("@ContactPersonNo", SqlDbType.VarChar, 50).Value = m_SalesMan.ContactPersonNo; scom.Parameters.Add("@CurrentStatus", SqlDbType.VarChar, 20).Value = m_SalesMan.CurrentStatus; scom.Parameters.Add("@Gradex", SqlDbType.VarChar, 20).Value = m_SalesMan.Gradex; scom.Parameters.Add("@NICNo", SqlDbType.VarChar, 20).Value = m_SalesMan.NICNo; scom.Parameters.Add("@InsMode", SqlDbType.Int).Value = formMode; // For insert scom.Parameters.Add("@RtnValue", SqlDbType.Int).Value = 0; u_DBConnection dbcon = new u_DBConnection(); retvalue = dbcon.RunQuery(scom); return(retvalue); } catch (Exception ex) { throw (ex); } }