public Int32 Update()
{
if (Session["bol.ticket"] != null)
{
BOL.tickets _ticket = (BOL.tickets)Session["bol.ticket"];
bol_ticketfeedback = new BOL.ticketfeedback();
manager_tickets = new Manager.tickets();
manager_ticketfeedback = new Manager.ticketfeedback();
if (_ticket != null)
{
_ticket.Title = txtTickettitle.Text;
_ticket.Description = txtTicketDescription.Text;
_ticket.Modifiedby = Convert.ToInt32(Session["userid"]);
_ticket.Modifiedon = DateTime.Now;
_ticket.Ticketstatusid = Convert.ToInt32(ddlTicketStatus.SelectedValue);
manager_tickets.Update(_ticket);
bol_ticketfeedback.Ticketid = _ticket.Ticketid;
bol_ticketfeedback.Feedback = txtfeedback.Text;
bol_ticketfeedback.Isdeleted = "F";
bol_ticketfeedback.Userid = _ticket.Modifiedby;
manager_ticketfeedback.Insert(bol_ticketfeedback);
}
}
return(0);
}
public Int32 Insert(BOL.ticketfeedback obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_ticketfeedback.Insert(obj, conn, trans);
Int32 ticketfeedback = bll_utility.GetMaxId("ticketfeedback", "Ticketfeedbackid", conn, trans);
trans.Commit();
conn.Close();
return(ticketfeedback);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
public DataSet Select(BOL.ticketfeedback obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@"SELECT `ticketfeedbackid`, `ticketid`, `userid`, `feedback`, `isdeleted`,`createdon` FROM `ticketfeedback` WHERE ");
if (obj.Ticketfeedbackid > 0)
{
qry.Append("`ticketfeedbackid` = " + obj.Ticketfeedbackid + " AND");
}
if (obj.Ticketid > 0)
{
qry.Append("`ticketid` = " + obj.Ticketid + " AND");
}
if (obj.Userid > 0)
{
qry.Append("`userid` = " + obj.Userid + " AND");
}
if (!string.IsNullOrEmpty(obj.Feedback))
{
qry.Append("`feedback` = '" + obj.Feedback + "' AND");
}
qry = qry.Remove(qry.Length - 3, 3);
return(dbconnect.GetDataset(conn, trans, qry.ToString()));
}
return(null);
}
public DataSet GetAllFeedbacksByTicket(BOL.ticketfeedback obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@" SELECT fb.ticketfeedbackid, fb.ticketid, fb.userid, fb.createdon, fb.feedback, fb.isdeleted,
u.username, c.mobile AS customermobile
FROM ticketfeedback fb
INNER JOIN users u ON u.userid = fb.userid
INNER JOIN tickets t ON t.ticketid = fb.ticketid
INNER JOIN customers c ON c.customerid = t.customerid
WHERE ");
if (obj.Ticketfeedbackid > 0)
{
qry.Append("fb.ticketfeedbackid = " + obj.Ticketfeedbackid + " AND");
}
if (obj.Ticketid > 0)
{
qry.Append("fb.ticketid = " + obj.Ticketid + " AND");
}
if (obj.Userid > 0)
{
qry.Append("fb.userid = " + obj.Userid + " AND");
}
if (!string.IsNullOrEmpty(obj.Feedback))
{
qry.Append("fb.feedback = '" + obj.Feedback + "' AND");
}
qry = qry.Remove(qry.Length - 3, 3);
return(dbconnect.GetDataset(conn, trans, qry.ToString()));
}
return(null);
}
public List <BOL.ticketfeedback> Select(BOL.ticketfeedback obj)
{
if (obj != null)
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
DataSet ds = bll_ticketfeedback.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.ticketfeedback> ticketfeedbackes = new List <BOL.ticketfeedback>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
BOL.ticketfeedback c = new BOL.ticketfeedback();
if (dr["Ticketfeedbackid"] != null && Convert.ToInt32(dr["Ticketfeedbackid"]) > 0)
{
c.Ticketfeedbackid = Convert.ToInt32(Convert.ToString(dr["Ticketfeedbackid"]));
}
if (dr["Feedback"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Feedback"])))
{
c.Feedback = Convert.ToString(dr["Feedback"]);
}
//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["Isdeleted"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Isdeleted"])))
{
c.Isdeleted = Convert.ToString(dr["Isdeleted"]);
}
//if (dr["Modifyby"] != null && Convert.ToInt32(dr["Modifyby"]) > 0)
//{
// c.Modifiedby = Convert.ToInt32(Convert.ToString(dr["Modifyby"]));
//}
//if (dr["Modifyon"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Modifyon"])))
//{
// c.Modifiedon = Convert.ToDateTime(Convert.ToString(dr["Modifyon"]));
//}
ticketfeedbackes.Add(c);
}
return(ticketfeedbackes);
}
return(null);
}
return(null);
}
public Int32 Delete(BOL.ticketfeedback obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"DELETE FROM `ticketfeedback` WHERE `ticketfeedbackid`= " + obj.Ticketfeedbackid;
dbconnect.ExecuteNonQuery(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Update(BOL.ticketfeedback obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"UPDATE `ticketfeedback` SET `ticketid`= " + obj.Ticketid + ",`userid`=" + obj.Userid +
",feedback`=" + obj.Feedback + ",`isdeleted` = '" + obj.Isdeleted + "' WHERE `ticketfeedbackid`= " + obj.Ticketfeedbackid;
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public Int32 Insert(BOL.ticketfeedback obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
try
{
string qry = @"INSERT INTO `ticketfeedback`(`ticketid`, `userid`, `feedback`, `isdeleted`, `Createdon`)
VALUES (" + obj.Ticketid + "," + obj.Userid + ",'" + obj.Feedback + "','F',STR_TO_DATE('" + obj.Createdon + "', '%c/%e/%Y %r'))";
dbconnect.GetScalar(conn, trans, qry, null);
return(1);
}
catch
{
}
}
return(0);
}
public void LoadTicket()
{
if (Request.QueryString["id"] != null && Convert.ToInt32(Convert.ToString(Request.QueryString["id"])) > 0)
{
manager_tickets = new Manager.tickets();
manager_ticketfeedback = new Manager.ticketfeedback();
manager_ticketattachment = new Manager.ticketattachment();
bol_tickets = new BOL.tickets();
bol_ticketfeedback = new BOL.ticketfeedback();
bol_ticketattachment = new BOL.ticketattachment();
bol_tickets.Ticketid = Convert.ToInt32(Convert.ToString(Request.QueryString["id"]));
List <BOL.tickets> _ticketses = manager_tickets.Select(bol_tickets);
if (_ticketses != null && _ticketses.Count > 0 && _ticketses[0].Ticketid > 0)
{
txtTickettitle.Text = _ticketses[0].Title;
txtTicketDescription.Text = _ticketses[0].Description;
ddlTicketStatus.SelectedValue = _ticketses[0].Ticketstatusid.ToString();
bol_ticketfeedback.Ticketid = _ticketses[0].Ticketid;
bol_ticketattachment.Ticketid = _ticketses[0].Ticketid;
_ticketses[0].Ticketfeedbacks = manager_ticketfeedback.GetAllFeedbacksByTicket(bol_ticketfeedback);
_ticketses[0].Ticketattachments = manager_ticketattachment.Select(bol_ticketattachment);
if (_ticketses[0].Ticketfeedbacks != null && _ticketses[0].Ticketfeedbacks.Count > 0)
{
_ticketses[0].Ticketfeedbacks.OrderByDescending(t => t.Ticketfeedbackid);
txtfeedback.Text = _ticketses[0].Ticketfeedbacks[0].Feedback;
repFeedbackHistory.DataSource = _ticketses[0].Ticketfeedbacks.OrderByDescending(t => t.Ticketfeedbackid);
repFeedbackHistory.DataBind();
}
repAttachment.DataSource = _ticketses[0].Ticketattachments.OrderByDescending(t => t.Ticketattachmentid);
repAttachment.DataBind();
Session["bol.ticket"] = _ticketses[0];
}
}
}
public Int32 Delete(BOL.ticketfeedback obj)
{
if (obj != null)
{
try
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
bll_ticketfeedback.Delete(obj, conn, trans);
trans.Commit();
conn.Close();
return(obj.Ticketfeedbackid);
}
catch
{
trans.Rollback();
conn.Close();
}
}
return(0);
}
public List <BOL.ticketfeedback> GetAllFeedbacksByTicket(BOL.ticketfeedback obj)
{
if (obj != null && obj.Ticketid > 0)
{
conn = new MySqlConnection(ConnectionString);
conn.Open();
trans = conn.BeginTransaction();
DataSet ds = bll_ticketfeedback.GetAllFeedbacksByTicket(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.ticketfeedback> ticketfeedbackes = new List <BOL.ticketfeedback>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
BOL.ticketfeedback c = new BOL.ticketfeedback();
if (dr["Ticketfeedbackid"] != null && Convert.ToInt32(dr["Ticketfeedbackid"]) > 0)
{
c.Ticketfeedbackid = Convert.ToInt32(Convert.ToString(dr["Ticketfeedbackid"]));
}
if (dr["Feedback"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Feedback"])))
{
c.Feedback = Convert.ToString(dr["Feedback"]);
}
if (dr["Userid"] != null && Convert.ToInt32(dr["Userid"]) > 0)
{
c.Userid = Convert.ToInt32(Convert.ToString(dr["Userid"]));
if (ds.Tables[0].Columns.Contains("username") && dr["username"] != null &&
!string.IsNullOrEmpty(Convert.ToString(dr["username"])))
{
c.Users = new BOL.users();
c.Users.Userid = Convert.ToInt32(dr["Userid"]);
c.Users.Username = Convert.ToString(dr["username"]);
}
}
if (ds.Tables[0].Columns.Contains("customermobile") && dr["customermobile"] != null &&
!string.IsNullOrEmpty(Convert.ToString(dr["customermobile"])))
{
c.Customers = new BOL.customers();
c.Customers.Mobile = Convert.ToString(dr["customermobile"]);
}
//
if (dr["Createdon"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Createdon"])))
{
c.Createdon = Convert.ToDateTime(Convert.ToString(dr["Createdon"]));
}
if (dr["Isdeleted"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Isdeleted"])))
{
c.Isdeleted = Convert.ToString(dr["Isdeleted"]);
}
//if (dr["Modifyby"] != null && Convert.ToInt32(dr["Modifyby"]) > 0)
//{
// c.Modifiedby = Convert.ToInt32(Convert.ToString(dr["Modifyby"]));
//}
//if (dr["Modifyon"] != null && !string.IsNullOrEmpty(Convert.ToString(dr["Modifyon"])))
//{
// c.Modifiedon = Convert.ToDateTime(Convert.ToString(dr["Modifyon"]));
//}
ticketfeedbackes.Add(c);
}
return(ticketfeedbackes);
}
return(null);
}
return(null);
}
