public string addticketsAssignment(SqlConnection conn, SqlTransaction trans, Ticket ticket) { ConnectionDao connectiondao = new ConnectionDao(); string strreturn = IdProConstants.SUCCESS; SqlCommand cmd = null; SqlDataReader rs = null; // int TICKETNOTEID = 0; string query = "INSERT INTO TicketAssignment([ticketid],[assignby],[assignto],[assigndate])VALUES (@ticketid,@assignby,@assignto,@assigndate)"; try { cmd = connectiondao.getSqlCommand(query, conn, trans); SqlParameter parm1 = new SqlParameter(); parm1.ParameterName = "@ticketid"; parm1.Value = ticket.ticketid; cmd.Parameters.Add(parm1); SqlParameter parm2 = new SqlParameter(); parm2.ParameterName = "@assignby"; parm2.Value = HttpContext.Current.Session["username"]; cmd.Parameters.Add(parm2); SqlParameter parm3 = new SqlParameter(); parm3.ParameterName = "@assignto"; parm3.Value = ticket.assignto; cmd.Parameters.Add(parm3); SqlParameter parm4 = new SqlParameter(); parm4.ParameterName = "@assigndate"; parm4.Value = ticket.assigndate; cmd.Parameters.Add(parm4); rs = cmd.ExecuteReader(); if (rs.Read()) { // TICKETAssignment = Int32.Parse(rs["Assignid"].ToString()); } } catch (Exception exception) { System.Diagnostics.Trace.WriteLine("[TicketDao:addticketsTypedetail] Exception " + exception.StackTrace); } finally { connectiondao.closeDabaseEntities(cmd, rs); } return strreturn; }
public string TicketAdd(Ticket ticket) { SqlConnection conn = null; SqlTransaction trans = null; string returnString = IdProConstants.SUCCESS; TicketDao ticketdao = new TicketDao(); ConnectionDao ConnectionDao = new ConnectionDao(); try { conn = ConnectionDao.getConnection(); trans = conn.BeginTransaction(); //ticket.tickettypeid = ticketdao.addticketsTypedetail(conn, trans, ticket); //if (!ticket.tickettypeid.Equals(0)) //{ ticket.ticketid = ticketdao.addticketsdetail(conn, trans, ticket); if (!ticket.ticketid.Equals(0)) { ticket.noteid = ticketdao.addticketsNotedetail(conn, trans, ticket); if (!ticket.noteid.Equals(0)) { returnString = ticketdao.addticketsAssignment(conn, trans, ticket); } else { trans.Commit(); } } else { trans.Rollback(); } trans.Commit(); } //else //{ // trans.Rollback(); //} //} catch (Exception exception) { trans.Rollback(); System.Diagnostics.Trace.WriteLine("[EmployeeServices:addEmployee] Exception " + exception.StackTrace); } finally { ConnectionDao.closeConnection(conn); } return returnString; }
public int addticketsdetail(SqlConnection conn, SqlTransaction trans, Ticket ticket) { ConnectionDao connectiondao = new ConnectionDao(); // string strreturn = IdProConstants.SUCCESS; SqlCommand cmd = null; SqlDataReader rs = null; int TICKETID = 0; string query = "INSERT INTO Ticket([accountid],[tickettype],[assignto],[Assignby],[opendate],[closedate],[status],[priority],[assigndate])VALUES (@accountid,@tickettype,@assignto,@Assignby,@opendate,@closedate,@status,@priority,@assigndate);SELECT ticketid=scope_identity();"; try { cmd = connectiondao.getSqlCommand(query, conn, trans); SqlParameter parm1 = new SqlParameter(); parm1.ParameterName = "@accountid"; parm1.Value = HttpContext.Current.Session["AccountID"]; cmd.Parameters.Add(parm1); SqlParameter parm2 = new SqlParameter(); parm2.ParameterName = "@tickettype"; parm2.Value = ticket.tickettypestring ; cmd.Parameters.Add(parm2); SqlParameter parm3 = new SqlParameter(); parm3.ParameterName = "@assignto"; parm3.Value = ticket.assignto; cmd.Parameters.Add(parm3); SqlParameter parm4 = new SqlParameter(); parm4.ParameterName = "@Assignby"; parm4.Value = HttpContext.Current.Session["username"]; cmd.Parameters.Add(parm4); SqlParameter parm5 = new SqlParameter(); parm5.ParameterName = "@opendate"; parm5.Value = ticket.assigndate; cmd.Parameters.Add(parm5); SqlParameter parm6 = new SqlParameter(); parm6.ParameterName = "@closedate"; parm6.Value = ""; cmd.Parameters.Add(parm6); SqlParameter parm7 = new SqlParameter(); parm7.ParameterName = "@status"; parm7.Value = "Open"; cmd.Parameters.Add(parm7); SqlParameter parm8 = new SqlParameter(); parm8.ParameterName = "@priority"; parm8.Value = ticket.priorty; cmd.Parameters.Add(parm8); SqlParameter parm9 = new SqlParameter(); parm9.ParameterName = "@assigndate"; parm9.Value = ticket.assigndate; cmd.Parameters.Add(parm9); rs = cmd.ExecuteReader(); if (rs.Read()) { TICKETID = Int32.Parse(rs["ticketid"].ToString()); } } catch (Exception exception) { System.Diagnostics.Trace.WriteLine("[TicketDao:addticketsdetail] Exception " + exception.StackTrace); } finally { connectiondao.closeDabaseEntities(cmd, rs); } return TICKETID; }
public Ticket getticketid(string ticketid) { ConnectionDao connectionDao = new ConnectionDao(); Ticket ticket = new Ticket(); SqlCommand cmd = null; SqlConnection conn = null; SqlDataReader rs = null; HttpContext.Current.Session["accountid"] = "1006"; string query = "select * from Ticket where accountid='" + HttpContext.Current.Session["accountid"] + "'"; try { conn = connectionDao.getConnection(); cmd = connectionDao.getSqlCommandWithoutTransaction(query, conn); rs = cmd.ExecuteReader(); if (rs.Read()) { ticket.ticketgetid = (rs["ticketid"].ToString().Trim()); strid = Convert.ToString(ticket.ticketgetid); } else { ticket = null; } } catch (Exception exception) { System.Diagnostics.Trace.WriteLine("[TicketDao:getticketid] Exception " + exception.StackTrace); ticket = null; } finally { connectionDao.closeConnection(conn); connectionDao.closeDabaseEntities(cmd, rs); } return ticket; }
public int addticketsTypedetail(SqlConnection conn, SqlTransaction trans, Ticket ticket) { ConnectionDao connectiondao = new ConnectionDao(); // string strreturn = IdProConstants.SUCCESS; SqlCommand cmd = null; SqlDataReader rs = null; int TICKETNOTEID = 0; string query = "INSERT INTO TicketType([Tickettype],[Priority],[assignment])VALUES (@Tickettype,@Priority,@assignment);SELECT TicketType_id=scope_identity();"; try { cmd = connectiondao.getSqlCommand(query, conn, trans); SqlParameter parm1 = new SqlParameter(); parm1.ParameterName = "@Tickettype"; parm1.Value = ticket.tickettypestring; cmd.Parameters.Add(parm1); SqlParameter parm2 = new SqlParameter(); parm2.ParameterName = "@Priority"; parm2.Value = ticket.priorty; cmd.Parameters.Add(parm2); SqlParameter parm3 = new SqlParameter(); parm3.ParameterName = "@assignment"; parm3.Value = ticket.assignto; cmd.Parameters.Add(parm3); rs = cmd.ExecuteReader(); if (rs.Read()) { TICKETNOTEID = Int32.Parse(rs["TicketType_id"].ToString()); } } catch (Exception exception) { System.Diagnostics.Trace.WriteLine("[TicketDao:addticketsTypedetail] Exception " + exception.StackTrace); } finally { connectiondao.closeDabaseEntities(cmd, rs); } return TICKETNOTEID; }
public int addticketsNotedetail(SqlConnection conn, SqlTransaction trans, Ticket ticket) { ConnectionDao connectiondao = new ConnectionDao(); SqlCommand cmd = null; SqlDataReader rs = null; int TICKETNOTEID = 0; string query = "INSERT INTO TicketNote([ticketid],[notedate],[note])VALUES (@ticketid,@notedate,@note);SELECT Noteid=scope_identity();"; // string query = "INSERT INTO TicketNote([ticketid],[note])VALUES (@ticketid,@note);SELECT Noteid=scope_identity();"; try { cmd = connectiondao.getSqlCommand(query, conn, trans); SqlParameter parm1 = new SqlParameter(); parm1.ParameterName = "@ticketid"; parm1.Value = ticket.ticketid; cmd.Parameters.Add(parm1); SqlParameter parm2 = new SqlParameter(); parm2.ParameterName = "@notedate"; parm2.Value = ticket.assigndate; cmd.Parameters.Add(parm2); SqlParameter parm3 = new SqlParameter(); parm3.ParameterName = "@note"; parm3.Value = ticket.note; cmd.Parameters.Add(parm3); rs = cmd.ExecuteReader(); if (rs.Read()) { TICKETNOTEID = Int32.Parse(rs["Noteid"].ToString()); } } catch (Exception exception) { System.Diagnostics.Trace.WriteLine("[TicketDao:addticketsNotedetail] Exception " + exception.StackTrace); } finally { connectiondao.closeDabaseEntities(cmd, rs); } return TICKETNOTEID; }