public static bool UpdateCustomerAddress(SELLERSADDRESS address) { bool status = false; try { using (OracleConnection connection = new OracleConnection(conlink)) { if (connection.State == ConnectionState.Closed) { connection.Open(); } string query = "UPDATE SELLERSADDRESS SET STREET= :street ,CITY = :city,DISTRICT= :district,STATE=:state,PINCODE=:pincode where ADDRESSID=:addid"; OracleCommand cmd = new OracleCommand(query, connection); cmd.Parameters.Add(new OracleParameter(":addid", address.ADDRESSID)); cmd.Parameters.Add(new OracleParameter(":street", address.STREET)); cmd.Parameters.Add(new OracleParameter(":city", address.CITY)); cmd.Parameters.Add(new OracleParameter(":district", address.DISTRICT)); cmd.Parameters.Add(new OracleParameter(":state", address.STATE)); cmd.Parameters.Add(new OracleParameter(":pincode", address.PINCODE)); cmd.ExecuteNonQuery(); if (connection.State == ConnectionState.Open) { connection.Close(); } status = true; } } catch (Exception ex) { throw ex; } return(status); }
public static List <SELLERSADDRESS> GetAll(int sellerId) { SELLERSADDRESS address = null; List <SELLERSADDRESS> addresses = new List <SELLERSADDRESS>(); try { using (OracleConnection con = new OracleConnection(conlink)) { if (con.State == ConnectionState.Closed) { con.Open(); } string query = "SELECT * FROM SELLERSADDRESS WHERE SELLERID=:sellerId"; OracleCommand cmd = new OracleCommand(query, con); cmd.Parameters.Add(new OracleParameter(":sellerId", sellerId)); OracleDataReader reader = cmd.ExecuteReader(); if (reader != null) { if (reader.HasRows) { while (reader.Read()) { address = new SELLERSADDRESS() { ADDRESSID = int.Parse(reader["ADDRESSID"].ToString()), SELLERID = int.Parse(reader["SELLERID"].ToString()), STREET = reader["STREET"].ToString(), CITY = reader["CITY"].ToString(), DISTRICT = reader["DISTRICT"].ToString(), STATE = reader["STATE"].ToString(), PINCODE = int.Parse(reader["PINCODE"].ToString()), }; addresses.Add(address); } reader.Close(); } } if (con.State == ConnectionState.Open) { con.Close(); } } } catch (Exception ex) { throw ex; } return(addresses); }
public static bool InsertCustomerAddress(SELLERSADDRESS address) { bool status = false; try { using (OracleConnection connection = new OracleConnection(conlink)) { if (connection.State == ConnectionState.Closed) { connection.Open(); } string query = "INSERT INTO SELLERSADDRESS (SELLERID,STREET,CITY,DISTRICT,STATE,PINCODE) " + "VALUES (:sellerId,:street,:city,:district,:state,:pincode)"; OracleCommand cmd = new OracleCommand(query, connection); cmd.Parameters.Add(new OracleParameter(":sellerId", address.SELLERID)); cmd.Parameters.Add(new OracleParameter(":street", address.STREET)); cmd.Parameters.Add(new OracleParameter(":city", address.CITY)); cmd.Parameters.Add(new OracleParameter(":district", address.DISTRICT)); cmd.Parameters.Add(new OracleParameter(":state", address.STATE)); cmd.Parameters.Add(new OracleParameter(":pincode", address.PINCODE)); cmd.ExecuteNonQuery(); if (connection.State == ConnectionState.Open) { connection.Close(); } status = true; } } catch (Exception ex) { throw ex; } return(status); }
// 5 update customer public static bool UpdateAddress(SELLERSADDRESS address) => SELLERSADDRESSDAL.UpdateCustomerAddress(address);
//4 insert customer public static bool InsertAddress(SELLERSADDRESS address) => SELLERSADDRESSDAL.InsertCustomerAddress(address);
// PUT: api/SellerAddress/5 public bool Put([FromBody] SELLERSADDRESS selleraddress) { return(SellerAddressBLL.UpdateAddress(selleraddress)); }
// POST: api/SellerAddress public bool Post([FromBody] SELLERSADDRESS selleraddress) { return(SellerAddressBLL.InsertAddress(selleraddress)); }