public Int32 Insert(BOL.customer_address obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_customer_address.Insert(obj, conn, trans);
Int32 customerid = bll_utility.GetMaxId("customer_address", "Custaddressid", conn, trans);
trans.Commit();
conn.Close();
return(customerid);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
public List <BOL.customer_address> Select(BOL.customer_address obj)
{
if (obj != null)
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
DataSet ds = bll_customer_address.Select(obj, conn, trans);
trans.Commit();
conn.Close();
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
List <BOL.customer_address> customer_addresses = new List <BOL.customer_address>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
BOL.customer_address c = new BOL.customer_address();
if (dr["Customerid"] != null && Convert.ToInt32(dr["Customerid"]) > 0)
{
c.Customerid = Convert.ToInt32(Convert.ToString(dr["Customerid"]));
}
if (dr["Custaddressid"] != null && Convert.ToInt32(dr["Custaddressid"]) > 0)
{
c.Custaddressid = Convert.ToInt32(Convert.ToString(dr["Custaddressid"]));
}
if (dr["Area"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Area"])))
{
c.Area = Convert.ToString(dr["Area"]);
}
if (dr["City"] != null && Convert.ToInt32(dr["City"]) > 0)
{
c.City = Convert.ToInt32(Convert.ToString(dr["City"]));
}
if (dr["House"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["House"])))
{
c.House = Convert.ToString(dr["House"]);
}
if (dr["Street"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Street"])))
{
c.Street = Convert.ToString(dr["Street"]);
}
if (dr["Country"] != null && Convert.ToInt32(dr["Country"]) > 0)
{
c.Country = Convert.ToInt32(Convert.ToString(dr["Country"]));
}
customer_addresses.Add(c);
}
return(customer_addresses);
}
return(null);
}
return(null);
}
public Int32 Delete(BOL.customer_address obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"DELETE FROM `customer_address` WHERE `custaddressid`= " + obj.Custaddressid;
dbconnect.ExecuteNonQuery(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Update(BOL.customer_address obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"UPDATE `customer_address` SET `customerid` = " + obj.Customerid + ",`house` = '" + obj.House +
"','street' = '" + obj.Street + "',`area`='" + obj.Area + "',city`=" + obj.City + ",`country` = " + obj.Country +
" WHERE `custaddressid`=" + obj.Custaddressid;
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Insert(BOL.customer_address obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"INSERT INTO `customer_address`(`customerid`, `house`, `street`, `area`, `city`, `country`)
VALUES (" + obj.Customerid + ",'" + obj.House + "','" + obj.Street + "','" + obj.Area + "'," + obj.City +
"," + obj.Country + ")";
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public DataSet Select(BOL.customer_address obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@"SELECT `custaddressid`, `customerid`, `house`, `street`, `area`, `city`, `country` FROM `customer_address` WHERE ");
if (obj.Custaddressid > 0)
{
qry.Append("`custaddressid` = " + obj.Custaddressid + " AND");
}
if (obj.Customerid > 0)
{
qry.Append("`customerid` = " + obj.Customerid + " AND");
}
qry = qry.Remove(qry.Length - 3, qry.Length);
return(dbconnect.GetDataset(conn, trans, qry.ToString()));
}
return(null);
}
public Int32 Delete(BOL.customer_address obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_customer_address.Delete(obj, conn, trans);
trans.Commit();
conn.Close();
return(obj.Customerid);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
