/// <summary> /// Saves a record to the M_CNTypes table. /// </summary> public Boolean Savem_CNTypeSP(M_CNTypes m_CNType, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "M_CNTypesSave"; scom.Parameters.Add("@TypeID", SqlDbType.VarChar, 20).Value = m_CNType.TypeID; scom.Parameters.Add("@TypeName", SqlDbType.VarChar, 40).Value = m_CNType.TypeName; scom.Parameters.Add("@UserCode", SqlDbType.VarChar, 20).Value = m_CNType.UserCode; scom.Parameters.Add("@Datex", SqlDbType.DateTime, 8).Value = m_CNType.Datex; 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); } }
public List <M_CNTypes> SelectM_CNTypeMulti(M_CNTypes objm_CNType2) { List <M_CNTypes> retval = new List <M_CNTypes>(); try { strquery = @"select * from M_CNTypes where TypeID = '" + objm_CNType2.TypeID + "'"; DataTable dtm_CNType = u_DBConnection.ReturnDataTable(strquery, CommandType.Text); foreach (DataRow drType in dtm_CNType.Rows) { if (drType != null) { M_CNTypes objm_CNType = new M_CNTypes(); objm_CNType.TypeID = drType["TypeID"].ToString(); objm_CNType.TypeName = drType["TypeName"].ToString(); objm_CNType.UserCode = drType["UserCode"].ToString(); objm_CNType.Datex = DateTime.Parse(drType["Datex"].ToString()); retval.Add(objm_CNType); } } return(retval); } catch (Exception ex) { throw ex; } }
public static string FindExisitingCNType(string suppcode) { string str = ""; if (M_CNTypeDL.ExistingM_CNType(suppcode.Trim())) { M_CNTypes cat = new M_CNTypes(); cat.TypeID = suppcode.Trim(); str = new M_CNTypeDL().Selectm_CNType(cat).TypeName; } else { str = "<Error!!!>"; } return(str); }
public M_CNTypes Selectm_CNType(M_CNTypes objm_CNType) { try { strquery = @"select * from M_CNTypes where TypeID = '" + objm_CNType.TypeID + "'"; DataRow drType = u_DBConnection.ReturnDataRow(strquery); if (drType != null) { objm_CNType.TypeID = drType["TypeID"].ToString(); objm_CNType.TypeName = drType["TypeName"].ToString(); objm_CNType.UserCode = drType["UserCode"].ToString(); objm_CNType.Datex = DateTime.Parse(drType["Datex"].ToString()); return(objm_CNType); } return(null); } catch (Exception ex) { throw ex; } }