public Int32 Insert(BOL.tickethistory obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_tickethistory.Insert(obj, conn, trans);
Int32 tickethistory = bll_utility.GetMaxId("tickethistory", "Tickethistoryid", conn, trans);
trans.Commit();
conn.Close();
return(tickethistory);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
public DataSet Select(BOL.tickethistory obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@"SELECT `tickethistoryid`, `ticketid`, `userid`, `ticketstatusid`,`createdon` FROM `tickethistory` WHERE ");
if (obj.Tickethistoryid > 0)
{
qry.Append("`tickethistoryid` = " + obj.Tickethistoryid + " AND");
}
if (obj.Ticketid > 0)
{
qry.Append("`ticketid` = " + obj.Ticketid + " AND");
}
if (obj.Userid > 0)
{
qry.Append("`userid` = " + obj.Userid + " AND");
}
if (obj.Ticketstatusid > 0)
{
qry.Append("`ticketstatusid` = " + obj.Ticketstatusid + " AND");
}
qry = qry.Remove(qry.Length - 3, qry.Length);
return(dbconnect.GetDataset(conn, trans, qry.ToString()));
}
return(null);
}
public List <BOL.tickethistory> Select(BOL.tickethistory obj)
{
if (obj != null)
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
DataSet ds = bll_tickethistory.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.tickethistory> tickethistoryes = new List <BOL.tickethistory>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
BOL.tickethistory c = new BOL.tickethistory();
if (dr["Tickethistoryid"] != null && Convert.ToInt32(dr["Tickethistoryid"]) > 0)
{
c.Tickethistoryid = Convert.ToInt32(Convert.ToString(dr["Tickethistoryid"]));
}
if (dr["Ticketid"] != null && Convert.ToInt32(dr["Ticketid"]) > 0)
{
c.Ticketid = Convert.ToInt32(Convert.ToString(dr["Ticketid"]));
}
if (dr["Ticketstatusid"] != null && Convert.ToInt32(dr["Ticketstatusid"]) > 0)
{
c.Ticketstatusid = Convert.ToInt32(Convert.ToString(dr["Ticketstatusid"]));
}
if (dr["Userid"] != null && Convert.ToInt32(dr["Userid"]) > 0)
{
c.Userid = Convert.ToInt32(Convert.ToString(dr["Userid"]));
}
if (dr["Createdon"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Createdon"])))
{
c.Createdon = Convert.ToDateTime(Convert.ToString(dr["Createdon"]));
}
tickethistoryes.Add(c);
}
return(tickethistoryes);
}
return(null);
}
return(null);
}
public Int32 Delete(BOL.tickethistory obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"DELETE FROM `tickethistory` WHERE `tickethistoryid`= " + obj.Tickethistoryid;
dbconnect.ExecuteNonQuery(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Update(BOL.tickethistory obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"UPDATE `tickethistory` SET `ticketid` = " + obj.Ticketid + ",`userid` = " + obj.Userid +
",ticketstatusid` = " + obj.Ticketstatusid + " WHERE `tickethistoryid` = " + obj.Tickethistoryid;
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Insert(BOL.tickethistory obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"INSERT INTO `tickethistory`(`ticketid`, `userid`, `ticketstatusid`, `Createdon`) VALUES
(" + obj.Ticketid + "," + obj.Userid + "," + obj.Ticketstatusid + ",STR_TO_DATE('" + obj.Createdon + "', '%c/%e/%Y %r'))";
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Delete(BOL.tickethistory obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_tickethistory.Delete(obj, conn, trans);
trans.Commit();
conn.Close();
return(obj.Tickethistoryid);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
