public bool UpdateMAKER(MAKER mAKER) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("AbiMatuEnterprise_UpdateMAKER", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@MAKERID", SqlDbType.Int).Value = mAKER.MAKERID; cmd.Parameters.Add("@MAKERNAME", SqlDbType.VarChar).Value = mAKER.MAKERNAME; cmd.Parameters.Add("@MAKERADDRESS1", SqlDbType.VarChar).Value = mAKER.MAKERADDRESS1; cmd.Parameters.Add("@MAKERADDRESS2", SqlDbType.VarChar).Value = mAKER.MAKERADDRESS2; cmd.Parameters.Add("@MAKERCITY", SqlDbType.VarChar).Value = mAKER.MAKERCITY; cmd.Parameters.Add("@MAKERSTATE", SqlDbType.Char).Value = mAKER.MAKERSTATE; cmd.Parameters.Add("@MAKERZIP", SqlDbType.VarChar).Value = mAKER.MAKERZIP; cmd.Parameters.Add("@MAKERPHONE1", SqlDbType.VarChar).Value = mAKER.MAKERPHONE1; cmd.Parameters.Add("@MAKERPHONE2", SqlDbType.VarChar).Value = mAKER.MAKERPHONE2; cmd.Parameters.Add("@MANAGER", SqlDbType.VarChar).Value = mAKER.MANAGER; cmd.Parameters.Add("@ACCOUNTNO", SqlDbType.VarChar).Value = mAKER.ACCOUNTNO; cmd.Parameters.Add("@ROUTINGNO", SqlDbType.VarChar).Value = mAKER.ROUTINGNO; cmd.Parameters.Add("@CHECKCOUNT", SqlDbType.Int).Value = mAKER.CHECKCOUNT; cmd.Parameters.Add("@CHECKAMOUNT", SqlDbType.Int).Value = mAKER.CHECKAMOUNT; cmd.Parameters.Add("@BADCHECKCOUNT", SqlDbType.Int).Value = mAKER.BADCHECKCOUNT; cmd.Parameters.Add("@BADCHECKAMOUNT", SqlDbType.Int).Value = mAKER.BADCHECKAMOUNT; cmd.Parameters.Add("@AMOUNTDUE", SqlDbType.Int).Value = mAKER.AMOUNTDUE; cmd.Parameters.Add("@CREATEDBY", SqlDbType.VarChar).Value = mAKER.CREATEDBY; cmd.Parameters.Add("@CREATEDON", SqlDbType.DateTime).Value = mAKER.CREATEDON; cmd.Parameters.Add("@UPDATEDBY", SqlDbType.VarChar).Value = mAKER.UPDATEDBY; cmd.Parameters.Add("@UPDATEDON", SqlDbType.DateTime).Value = mAKER.UPDATEDON; cmd.Parameters.Add("@ISOFACVERIFIED", SqlDbType.Char).Value = mAKER.ISOFACVERIFIED; cmd.Parameters.Add("@MAKERREMARKS", SqlDbType.VarChar).Value = mAKER.MAKERREMARKS; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public static MAKER GetMAKERByID(int id) { MAKER mAKER = new MAKER(); SqlMAKERProvider sqlMAKERProvider = new SqlMAKERProvider(); mAKER = sqlMAKERProvider.GetMAKERByID(id); return(mAKER); }
public MAKER GetMAKERFromReader(IDataReader reader) { try { MAKER mAKER = new MAKER ( (int)reader["MAKERID"], reader["MAKERNAME"].ToString(), reader["MAKERADDRESS1"].ToString(), reader["MAKERADDRESS2"].ToString(), reader["MAKERCITY"].ToString(), (char)reader["MAKERSTATE"], reader["MAKERZIP"].ToString(), reader["MAKERPHONE1"].ToString(), reader["MAKERPHONE2"].ToString(), reader["MANAGER"].ToString(), reader["ACCOUNTNO"].ToString(), reader["ROUTINGNO"].ToString(), (int)reader["CHECKCOUNT"], (int)reader["CHECKAMOUNT"], (int)reader["BADCHECKCOUNT"], (int)reader["BADCHECKAMOUNT"], (int)reader["AMOUNTDUE"], reader["CREATEDBY"].ToString(), (DateTime)reader["CREATEDON"], reader["UPDATEDBY"].ToString(), (DateTime)reader["UPDATEDON"], (char)reader["ISOFACVERIFIED"], reader["MAKERREMARKS"].ToString() ); return(mAKER); } catch (Exception ex) { return(null); } }
public static bool UpdateMAKER(MAKER mAKER) { SqlMAKERProvider sqlMAKERProvider = new SqlMAKERProvider(); return(sqlMAKERProvider.UpdateMAKER(mAKER)); }
public static int InsertMAKER(MAKER mAKER) { SqlMAKERProvider sqlMAKERProvider = new SqlMAKERProvider(); return(sqlMAKERProvider.InsertMAKER(mAKER)); }