public ActionResult UpdateTickets(BlTickets ObjBlTickets)
{
if (Session["ID_Users"] == "" || Session["ID_Users"] == "null")
{
Session["ID_Users"] = "0";
}
ObjBlTickets.UserCode = Convert.ToInt64(Session["ID_Users"]);
ObjBlTickets.FK_Company = Convert.ToInt64(Session["ID_Company"]);
ObjBlTickets.AgentCode = Convert.ToInt64(Session["ID_Agent"]);
ObjBlTickets.XmlAttachment = attname;
long statusCode = 0;
if (ObjBlTickets.MasterID == 0)
{
statusCode = ObjBlTickets.InsertData();
}
else
{
statusCode = ObjBlTickets.UpdateData();
}
ObjBlTickets = null;
attname = "";
return(Json(new { statusCode = "" + statusCode + "" }, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateTicketAssign(BlTickets ObjBlTickets)
{
ObjBlTickets.FK_Company = Convert.ToInt64(Session["ID_Company"]);
ObjBlTickets.AgentCode = Convert.ToInt64(Session["ID_Agent"]);
long statusCode = 0;
statusCode = ObjBlTickets.UpdateTicketAssign();
ObjBlTickets = null;
return(Json(new { statusCode = "" + statusCode + "" }, JsonRequestBehavior.AllowGet));
}
public ActionResult UpdateTicketDetails(BlTickets ObjBlTickets)
{
ObjBlTickets.FK_Company = Convert.ToInt64(Session["ID_Company"]);
ObjBlTickets.AgentCode = Convert.ToInt64(Session["ID_Agent"]);
ObjBlTickets.XmlAttachment = attname;
long statusCode = 0;
statusCode = ObjBlTickets.UpdateTicketDetails();
ObjBlTickets = null;
attname = "";
return(Json(new { statusCode = "" + statusCode + "" }, JsonRequestBehavior.AllowGet));
}
public JsonResult DeleteResumes(Int64 ID_Tickets)
{
try
{
long statusCode = 0;
BlTickets BlTickets = new BlTickets();
BlTickets.MasterID = ID_Tickets;
BlTickets.UserCode = Convert.ToInt64(Session["ID_Agent"]);
BlTickets.FK_Company = Convert.ToInt64(Session["ID_Company"]);
statusCode = BlTickets.DeleteData();
return(Json(new { statusCode = "" + statusCode + "" }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex));
}
}
public JsonResult FillTickets(Int64 ID_Tickets)
{
try
{
DataTable dtbl = new DataTable();
BlTickets bltickets = new BlTickets();
bltickets.UserCode = Convert.ToInt64(Session["ID_Agent"]);
bltickets.FK_Company = Convert.ToInt64(Session["ID_Company"]);
bltickets.MasterID = ID_Tickets;
dtbl = bltickets.SelectAllData();
return(Json(Converttojson(dtbl), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(ex));
}
}
public JsonResult SelectAgentTicketDetails(string ID_Tickets)
{
try
{
int statusCode = 1;
DataTable dtbl = new DataTable();
BlTickets bltickets = new BlTickets();
bltickets.FK_Company = Convert.ToInt64(Session["ID_Company"]);
bltickets.MasterID = Convert.ToInt64(ID_Tickets);
dtbl = bltickets.SelectAgentTicketDetails();
return(Json(Converttojson(dtbl), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
///
return(Json(ex));
}
}
public JsonResult SelectTicketsAll(string PageIndex = "1", string SearchItem = "", string Status = "0")
{
try
{
int statusCode = 1;
DataTable dtbl = new DataTable();
BlTickets bltickets = new BlTickets();
bltickets.UserCode = Convert.ToInt64(Session["ID_Agent"]);
bltickets.FK_Company = Convert.ToInt64(Session["ID_Company"]);
bltickets.TickStatus = Convert.ToInt16(Status);
bltickets.TickNo = SearchItem;
bltickets.TickSubject = SearchItem;
bltickets.ClientName = SearchItem;
bltickets.PageIndex = Convert.ToInt32(PageIndex);
dtbl = bltickets.SelectAllData();
return(Json(Converttojson(dtbl), JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
///
return(Json(ex));
}
}
public ActionResult UpdateTicketAssign(BlTickets ObjBlTickets)
{
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
ObjBlTickets.FK_Company = Convert.ToInt64(Session["ID_Company"]);
ObjBlTickets.AgentCode = Convert.ToInt64(Session["ID_Agent"]);
long statusCode = 0;
statusCode = ObjBlTickets.UpdateTicketAssign();
try
{
BlAgent blAgent = new BlAgent();
blAgent.MasterID = ObjBlTickets.AgentCode;
ds = blAgent.SelectAllData();
DataTable Dt = ds.Tables[0];
var Fromagent = Dt.Rows[0]["AgName"].ToString();
blAgent = null;
BlAgent blAgentto = new BlAgent();
blAgentto.MasterID = ObjBlTickets.AgentTo;
ds1 = blAgentto.SelectAllData();
DataTable Dt1 = ds1.Tables[0];
var toagent = Dt1.Rows[0]["AgName"].ToString();
List <string> toagentmailid = new List <string>();
toagentmailid.Add(Dt1.Rows[0]["Agemail"].ToString());
blAgentto = null;
List <string> resumesids = new List <string>();
if (ObjBlTickets.MasterID != 0)
{
resumesids.Add(ObjBlTickets.MasterID.ToString());
}
else
{
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.LoadXml(ObjBlTickets.XmlTickets);
string xpath = "root/Tickets/ID_Tickets";
var nodes = xmlDoc.SelectNodes(xpath);
foreach (XmlNode childrenNode in nodes)
{
resumesids.Add(childrenNode.InnerText);
}
}
// DataTable dt2= ObjBlTickets.SelectAllData();
var resumeno = ""; ///dt2.Rows[0]["TickNo"].ToString();
//var candidatename = dt2.Rows[0]["CandidateName"].ToString();
string htmlbody = "<p><strong> SMART RECRUITER RESUME ASSIGNED </strong></p> <p>Hi " + toagent + ", </p>";
htmlbody += "<p><a href='" + ConfigurationManager.AppSettings["api-url"] + "/Resumes/Resumes'> Click here </a> to View All resumes</p>";
htmlbody += "<p>Please find this <strong>";
foreach (var res in resumesids)
{
htmlbody += "<a href='" + ConfigurationManager.AppSettings["api-url"] + "/Resumes/Resumes?ID_Resumes=" + res + "'> RESUME " + resumeno + "</a></strong><br/>";
}
// htmlbody += " <p>Candidate Name : <strong>"+ candidatename + "</strong><br />";
htmlbody += "<br />";
htmlbody += "Assigned by : " + Fromagent + " in SmartRecruiter</p>";
SendMail("SMARTRECRUITER RESUME ASSIGNED", htmlbody, toagentmailid);
}
catch (Exception ex)
{
}
ObjBlTickets = null;
return(Json(new { statusCode = "" + statusCode + "" }, JsonRequestBehavior.AllowGet));
}