public DataSet Select(BOL.OwaisBOL c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@"SELECT `idNumber`, `firstName`, `lastName`, `status`, `email` FROM `owais` WHERE ");
if (c.IdNumber > 0)
{
qry.Append("`idNumber` = " + c.IdNumber + " AND");
}
if (!string.IsNullOrEmpty(c.FirstName))
{
qry.Append("`firstName` = '" + c.FirstName + "' AND");
}
if (!string.IsNullOrEmpty(c.LastName))
{
qry.Append("`lastName` = '" + c.LastName + "' AND");
}
if (!string.IsNullOrEmpty(c.Email))
{
qry.Append("`email` = '" + c.Email + "' AND");
}
else
{
qry.Append(" 1 AND");
}
qry = qry.Remove(qry.Length - 3, 3);
return(dbconnect.GetDataset(conn, trans, qry.ToString()));
}
return(null);
}
public Int32 Insert(BOL.OwaisBOL obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_objOwaisBLL.Insert(obj, conn, trans);
Int32 idNumber = bll_utility.GetMaxId("owais", "IdNumber", conn, trans);
trans.Commit();
conn.Close();
return(idNumber);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
public void Initialize()
{
manager_OwaisManager = new OwaisManager();
//manager_customer_address = new Manager.customer_address();
manager_status = new Manager.status();
utility = new Utility();
bol_statuses = new List <BOL.status>();
bol_OwaisBOL = new OwaisBOL();
}
public List <BOL.OwaisBOL> Select(BOL.OwaisBOL obj)
{
if (obj != null)
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
DataSet ds = bll_objOwaisBLL.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.OwaisBOL> owais = new List <BOL.OwaisBOL>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
BOL.OwaisBOL c = new BOL.OwaisBOL();
if (dr["IdNumber"] != null && Convert.ToInt32(dr["IdNumber"]) > 0)
{
c.IdNumber = Convert.ToInt32(Convert.ToString(dr["IdNumber"]));
}
if (dr["FirstName"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["FirstName"])))
{
c.FirstName = Convert.ToString(dr["FirstName"]);
}
if (dr["LastName"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["LastName"])))
{
c.LastName = Convert.ToString(dr["LastName"]);
}
if (dr["Email"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Email"])))
{
c.Email = Convert.ToString(dr["Email"]);
}
if (dr["Status"] != null && Convert.ToInt32(dr["Status"]) > 0)
{
c.Status = Convert.ToInt32(Convert.ToString(dr["Status"]));
}
owais.Add(c);
}
return(owais);
}
return(null);
}
return(null);
}
public Int32 Delete(BOL.OwaisBOL c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
try
{
string qry = @"DELETE FROM `owais` WHERE `idNumber`= " + c.IdNumber;
dbconnect.ExecuteNonQuery(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Update(BOL.OwaisBOL c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
try
{
string qry = @"UPDATE `owais` SET `firstName` ='" + c.FirstName + "',`lastName`='" + c.LastName +
"',status`=" + c.Status + ",`email`='" + c.Email + "',`idNumber` =" + c.IdNumber;
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Insert(BOL.OwaisBOL c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
try
{
string qry = @"INSERT INTO `owais`(`idNumber`, `firstName`, `lastName`,
`Email`, `Status`)
VALUES ('" + c.IdNumber + "','" + c.FirstName + "','" + c.LastName + "','" + c.Email
+ "','" + c.Status + "')";
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Delete(BOL.OwaisBOL obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_objOwaisBLL.Delete(obj, conn, trans);
trans.Commit();
conn.Close();
return(obj.IdNumber);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
