public bool AddMPayTypeLedger(MPayTypeLedger mpaytypeledger) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddMPayTypeLedger"; cmd.Parameters.AddWithValue("@PKPayTypeLedgerNo", mpaytypeledger.PKPayTypeLedgerNo); cmd.Parameters.AddWithValue("@PayTypeNo", mpaytypeledger.PayTypeNo); cmd.Parameters.AddWithValue("@LedgerNo", mpaytypeledger.LedgerNo); cmd.Parameters.AddWithValue("@CompanyNo", mpaytypeledger.CompanyNo); cmd.Parameters.AddWithValue("@ChargesPerce", mpaytypeledger.ChargesPerce); if (ObjTrans.ExecuteNonQuery(cmd, CommonFunctions.ConStr) == true) { return(true); } else { mpaytypeledger.msg = ObjTrans.ErrorMessage; return(false); } }
public MPayTypeLedger ModifyMPayTypeByID(int ID) { SqlConnection Con = new SqlConnection(CommonFunctions.ConStr); string sql; SqlCommand cmd; sql = "Select * from MPayTypeLedger where PKPayTypeLedgerNo =" + ID; cmd = new SqlCommand(sql, Con); cmd.Connection = Con; Con.Open(); cmd.CommandType = CommandType.Text; SqlDataReader dr; dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); if (dr.HasRows) { MPayTypeLedger MM = new MPayTypeLedger(); while (dr.Read()) { MM.PKPayTypeLedgerNo = Convert.ToInt32(dr["PKPayTypeLedgerNo"]); if (!Convert.IsDBNull(dr["PayTypeNo"])) { MM.PayTypeNo = Convert.ToInt32(dr["PayTypeNo"]); } if (!Convert.IsDBNull(dr["LedgerNo"])) { MM.LedgerNo = Convert.ToInt64(dr["LedgerNo"]); } if (!Convert.IsDBNull(dr["CompanyNo"])) { MM.CompanyNo = Convert.ToInt32(dr["CompanyNo"]); } } dr.Close(); return(MM); } else { dr.Close(); } return(new MPayTypeLedger()); }
public bool AddMPayTypeLedger(MPayTypeLedger mpaytypeledger) { SqlCommand cmd; cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "AddMPayTypeLedger"; cmd.Parameters.AddWithValue("@PKPayTypeLedgerNo", mpaytypeledger.PKPayTypeLedgerNo); // cmd.Parameters.AddWithValue("@PayTypeNo", mpaytypeledger.PayTypeNo); cmd.Parameters.AddWithValue("@LedgerNo", mpaytypeledger.LedgerNo); cmd.Parameters.AddWithValue("@CompanyNo", mpaytypeledger.CompanyNo); cmd.Parameters.AddWithValue("@ChargesPerce", mpaytypeledger.ChargesPerce); commandcollection.Add(cmd); return(true); }