public DataSet Select(BOL.Hunaid1BOL c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@"SELECT `id`, `fisrtName`, `lastName`, `cellNum`, `email` FROM `hunaid` ");
if (c.Id > 0)
{
qry.Append("`id` = " + c.Id + " AND");
}
if (!string.IsNullOrEmpty(c.FirstName))
{
qry.Append("`firstName` = '" + c.FirstName + "' AND");
}
if (!string.IsNullOrEmpty(c.LastName))
{
qry.Append("`lastName` = '" + c.LastName + "' AND");
}
if (Convert.ToInt32(c.CellNum) > 0)
{
qry.Append("`cellNum` = '" + c.CellNum + "' 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.Hunaid1BOL obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bllhunaid1obj.Insert(obj, conn, trans);
Int32 id = bll_utility.GetMaxId("hunaid", "id", conn, trans);
trans.Commit();
conn.Close();
return(id);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
public Int32 Delete(BOL.Hunaid1BOL c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
try
{
string qry = @"DELETE FROM `hunaid` WHERE `firstName`= " + c.FirstName;
dbconnect.ExecuteNonQuery(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Update(BOL.Hunaid1BOL c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
try
{
string qry = @"UPDATE `hunaid` SET `fisrtName`=" + c.FirstName + ",`lastName`=" + c.LastName + ",`cellNum`=" + c.CellNum + ",`email`=" + c.Email + " WHERE 1";
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Insert(BOL.Hunaid1BOL c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
try
{
string qry = @"INSERT INTO `hunaid`(`fisrtName`, `lastName`, `cellNum`, `email`)
VALUES (" + c.FirstName + "," + c.LastName + "," + c.CellNum + "," + c.Email + ")";
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Delete(BOL.Hunaid1BOL obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bllhunaid1obj.Delete(obj, conn, trans);
trans.Commit();
conn.Close();
return(obj.Id);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
public void Initialize()
{
mgrhunaid = new hunaidManager1();
bolhunaid = new Hunaid1BOL();
utility = new Utility();
}
public List <BOL.Hunaid1BOL> Select(BOL.Hunaid1BOL obj)
{
//if (obj != null)
//{
// conn = new MySqlConnection(ConnectionString);
// conn.Open();
// trans = conn.BeginTransaction();
// DataSet ds = bll_objCustomer.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.customers> customers = new List<BOL.customers>();
// foreach (DataRow dr in ds.Tables[0].Rows)
// {
// BOL.customers c = new BOL.customers();
// if (dr["Customerid"] != null && Convert.ToInt32(dr["Customerid"]) > 0)
// {
// c.Customerid = Convert.ToInt32(Convert.ToString(dr["Customerid"]));
// }
// if (dr["Firstname"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Firstname"])))
// {
// c.Firstname = Convert.ToString(dr["Firstname"]);
// }
// if (dr["Createdby"] != null && Convert.ToInt32(dr["Createdby"]) > 0)
// {
// c.Createdby = Convert.ToInt32(Convert.ToString(dr["Createdby"]));
// }
// if (dr["Createdon"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Createdon"])))
// {
// c.Createdon = Convert.ToDateTime(Convert.ToString(dr["Createdon"]));
// }
// if (dr["Email"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Email"])))
// {
// c.Email = Convert.ToString(dr["Email"]);
// }
// if (dr["Isdeleted"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Isdeleted"])))
// {
// c.Isdeleted = Convert.ToString(dr["Isdeleted"]);
// }
// if (dr["Lastname"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Lastname"])))
// {
// c.Lastname = Convert.ToString(dr["Lastname"]);
// }
// if (dr["Mobile"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Mobile"])))
// {
// c.Mobile = Convert.ToString(dr["Mobile"]);
// }
// if (dr["Modifyby"] != null && Convert.ToInt32(dr["Modifyby"]) > 0)
// {
// c.Modifyby = Convert.ToInt32(Convert.ToString(dr["Modifyby"]));
// }
// if (dr["Modifyon"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Modifyon"])))
// {
// c.Modifyon = Convert.ToDateTime(Convert.ToString(dr["Modifyon"]));
// }
// if (dr["Status"] != null && Convert.ToInt32(dr["Status"]) > 0)
// {
// c.Status = Convert.ToInt32(Convert.ToString(dr["Status"]));
// }
// customers.Add(c);
// }
// return customers;
// }
return(null);
}
