public Int32 Insert(BOL.AhmedRazaBOL obj) { if (obj != null) { try { conn = new MySqlConnection(ConnectionString); conn.Open(); trans = conn.BeginTransaction(); bll_objAhmedRazaBLL.Insert(obj, conn, trans); Int32 idNumber = bll_utility.GetMaxId("AhmedRaza", "IdNumber", conn, trans); trans.Commit(); conn.Close(); return(idNumber); } catch { trans.Rollback(); conn.Close(); } } return(0); }
public DataSet Select(BOL.AhmedRazaBOL c, MySqlConnection conn, MySqlTransaction trans) { if (c != null) { StringBuilder qry = new System.Text.StringBuilder(); qry.Append(@"SELECT `idNumber`, `firstName`, `lastName`, `status`, `email` FROM `AhmedRaza` 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 List <BOL.AhmedRazaBOL> Select(BOL.AhmedRazaBOL obj) { if (obj != null) { conn = new MySqlConnection(ConnectionString); conn.Open(); trans = conn.BeginTransaction(); DataSet ds = bll_objAhmedRazaBLL.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.AhmedRazaBOL> AhmedRaza = new List <BOL.AhmedRazaBOL>(); foreach (DataRow dr in ds.Tables[0].Rows) { BOL.AhmedRazaBOL c = new BOL.AhmedRazaBOL(); 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"])); } AhmedRaza.Add(c); } return(AhmedRaza); } return(null); } return(null); }
public Int32 Delete(BOL.AhmedRazaBOL c, MySqlConnection conn, MySqlTransaction trans) { if (c != null) { try { string qry = @"DELETE FROM `AhmedRaza` WHERE `idNumber`= " + c.IdNumber; dbconnect.ExecuteNonQuery(conn, trans, qry, null); return(1); } catch { } } return(0); }
public Int32 Update(BOL.AhmedRazaBOL c, MySqlConnection conn, MySqlTransaction trans) { if (c != null) { try { string qry = @"UPDATE `AhmedRaza` 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.AhmedRazaBOL c, MySqlConnection conn, MySqlTransaction trans) { if (c != null) { try { string qry = @"INSERT INTO `AhmedRaza`(`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.AhmedRazaBOL obj) { if (obj != null) { try { conn = new MySqlConnection(ConnectionString); conn.Open(); trans = conn.BeginTransaction(); bll_objAhmedRazaBLL.Delete(obj, conn, trans); trans.Commit(); conn.Close(); return(obj.IdNumber); } catch { trans.Rollback(); conn.Close(); } } return(0); }