public M_PayMode Selectm_PayMode(M_PayMode objm_PayMode) { try { strquery = @"select * from m_PayMode where id = '" + objm_PayMode.id + "'"; DataRow drType = u_DBConnection.ReturnDataRow(strquery); if (drType != null) { objm_PayMode.id = drType["id"].ToString(); objm_PayMode.description = drType["description"].ToString(); objm_PayMode.isActive = int.Parse(drType["isActive"].ToString()); objm_PayMode.isSubPaymode = int.Parse(drType["isSubPaymode"].ToString()); objm_PayMode.isAddBalance = int.Parse(drType["isAddBalance"].ToString()); objm_PayMode.isAdvancePayment = int.Parse(drType["isAdvancePayment"].ToString()); objm_PayMode.isControlOverPayment = int.Parse(drType["isControlOverPayment"].ToString()); objm_PayMode.isVoucher = int.Parse(drType["isVoucher"].ToString()); objm_PayMode.accountCode = drType["accountCode"].ToString(); objm_PayMode.CommissionAccCode = drType["CommissionAccCode"].ToString(); objm_PayMode.isCredit = int.Parse(drType["isCredit"].ToString()); objm_PayMode.isPoint = int.Parse(drType["isPoint"].ToString()); objm_PayMode.triggerVal = int.Parse(drType["triggerVal"].ToString()); objm_PayMode.ischeque = int.Parse(drType["ischeque"].ToString()); return(objm_PayMode); } return(null); } catch (Exception ex) { throw ex; } }
public static string FindExisitingPaytype(string suppcode) { string str = ""; if (M_PayModeDL.ExistingM_PayMode(suppcode.Trim())) { M_PayMode cat = new M_PayMode(); cat.id = suppcode.Trim(); str = new M_PayModeDL().Selectm_PayMode(cat).description; } else { str = "<Error!!!>"; } return(str); }
/// <summary> /// Saves a record to the M_PayMode table. /// </summary> public Boolean Savem_PayModeSP(M_PayMode m_PayMode, int formMode) { SqlCommand scom; bool retvalue = false; try { scom = new SqlCommand(); scom.CommandType = CommandType.StoredProcedure; scom.CommandText = "M_PayModeSave"; scom.Parameters.Add("@id", SqlDbType.VarChar, 10).Value = m_PayMode.id; scom.Parameters.Add("@description", SqlDbType.VarChar, 50).Value = m_PayMode.description; scom.Parameters.Add("@isActive", SqlDbType.Int, 4).Value = m_PayMode.isActive; scom.Parameters.Add("@isSubPaymode", SqlDbType.Int, 4).Value = m_PayMode.isSubPaymode; scom.Parameters.Add("@isAddBalance", SqlDbType.Int, 4).Value = m_PayMode.isAddBalance; scom.Parameters.Add("@isAdvancePayment", SqlDbType.Int, 4).Value = m_PayMode.isAdvancePayment; scom.Parameters.Add("@isControlOverPayment", SqlDbType.Int, 4).Value = m_PayMode.isControlOverPayment; scom.Parameters.Add("@isVoucher", SqlDbType.Int, 4).Value = m_PayMode.isVoucher; scom.Parameters.Add("@accountCode", SqlDbType.VarChar, 15).Value = m_PayMode.accountCode; scom.Parameters.Add("@CommissionAccCode", SqlDbType.VarChar, 15).Value = m_PayMode.CommissionAccCode; scom.Parameters.Add("@isCredit", SqlDbType.Int, 4).Value = m_PayMode.isCredit; scom.Parameters.Add("@isPoint", SqlDbType.Int, 4).Value = m_PayMode.isPoint; scom.Parameters.Add("@triggerVal", SqlDbType.Int, 4).Value = m_PayMode.triggerVal; scom.Parameters.Add("@ischeque", SqlDbType.Int, 4).Value = m_PayMode.ischeque; 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_PayMode> SelectM_PayModeMulti(M_PayMode objm_PayMode2) { List <M_PayMode> retval = new List <M_PayMode>(); try { strquery = @"select * from m_PayMode where id = '" + objm_PayMode2.id + "'"; DataTable dtm_PayMode = u_DBConnection.ReturnDataTable(strquery, CommandType.Text); foreach (DataRow drType in dtm_PayMode.Rows) { if (drType != null) { M_PayMode objm_PayMode = new M_PayMode(); objm_PayMode.id = drType["id"].ToString(); objm_PayMode.description = drType["description"].ToString(); objm_PayMode.isActive = int.Parse(drType["isActive"].ToString()); objm_PayMode.isSubPaymode = int.Parse(drType["isSubPaymode"].ToString()); objm_PayMode.isAddBalance = int.Parse(drType["isAddBalance"].ToString()); objm_PayMode.isAdvancePayment = int.Parse(drType["isAdvancePayment"].ToString()); objm_PayMode.isControlOverPayment = int.Parse(drType["isControlOverPayment"].ToString()); objm_PayMode.isVoucher = int.Parse(drType["isVoucher"].ToString()); objm_PayMode.accountCode = drType["accountCode"].ToString(); objm_PayMode.CommissionAccCode = drType["CommissionAccCode"].ToString(); objm_PayMode.isCredit = int.Parse(drType["isCredit"].ToString()); objm_PayMode.isPoint = int.Parse(drType["isPoint"].ToString()); objm_PayMode.triggerVal = int.Parse(drType["triggerVal"].ToString()); objm_PayMode.ischeque = int.Parse(drType["ischeque"].ToString()); retval.Add(objm_PayMode); } } return(retval); } catch (Exception ex) { throw ex; } }