public void newSeriveRequest(ServiceRequest obj)
{
string mid = System.Web.HttpContext.Current.Session["id"].ToString();
int purpose = obj.Purpose;
string srDescription = obj.SRDescription;
if (ModelState.IsValid)
{
try
{
SRNumber srn = new SRNumber(); /*BusinessLayer layer object */
int userID = Convert.ToInt32(srn.getUserId(mid));
string userMailID = TempData["userMailID"] as string;
// int SRID = Convert.ToInt32(srn.generateServiceRequestNumber());
// string retVal = srn.generateSRNumber(srDescription, purpose, obj.FromDate, obj.TillDate, userID, obj.UserLocation, obj.ContactNumber);
int SRID = srn.generateSRNumber(srDescription, purpose, obj.FromDate, obj.TillDate, userID, obj.UserLocation, obj.ContactNumber);
//srvalue = retVal;
srvalue = SRID.ToString();
Session["SRID"] = SRID;
Session["CountForSRDetails"] = 1;
Token tk = new Token();
tk.insertToken(SRID);
int RoleID = Convert.ToInt32(srn.generateRoleID(userID));
srn.generateServiceRequestStatusID(SRID, RoleID, userID);
createServiceRequestNumber(SRID);
}
catch (Exception EX)
{
ViewBag.Message("Error");
}
}
}
public JsonResult ReferExistingSR(string selection)
{
string MID = System.Web.HttpContext.Current.Session["id"].ToString();
SRNumber sR = new SRNumber();
if (selection == "Yes")
{
try
{
IEnumerable <SRNumber.showForGetExistingSR> getExistingSRs = sR.ReferExistingSR(MID);
if (getExistingSRs.Count() != 0)
{
return(Json(getExistingSRs, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
Log.CreateLog(ex);
}
}
return(Json(true, JsonRequestBehavior.AllowGet));
}
public ActionResult ExistingSR()
{
string MID = System.Web.HttpContext.Current.Session["id"].ToString();
SRNumber srn = new SRNumber();
string Role = srn.getRole(MID);
Session["Role"] = Role;
if (!string.IsNullOrEmpty(Session["ajax"] as string))
{
string status = Session["ajax"].ToString();
ViewBag.ExistingSR = srn.getSRDashboardSearch(MID, status, Role);
TempData["SRStatus"] = status;
Session["ajax"] = null;
}
else
{
ViewBag.ExistingSR = getExistingSR(MID);
}
string[] values = (ConfigurationManager.AppSettings["DropdownValues"]).Split(',').Select(sValue => sValue.Trim()).ToArray();
List <SelectListItem> dropDowns = new List <SelectListItem>(); for (int i = 0; i < values.Length; i++)
{
dropDowns.Add(new SelectListItem {
Text = values[i], Value = values[i]
});
}
ViewBag.DropdownVals = dropDowns;
ViewData["Status"] = getStatus();
return(View());
}
public ActionResult SRDetails(ApproverSRDetails obj)
{
string mid = System.Web.HttpContext.Current.Session["id"].ToString();
try
{
SRNumber srn = new SRNumber();
int userID = Convert.ToInt32(srn.getUserId(mid));
int RoleID = Convert.ToInt32(srn.generateRoleID(userID));
int count = Convert.ToInt32(System.Web.HttpContext.Current.Session["CountforSRDetails"]);
Session["CountforSRDetails"] = count;
string srid = System.Web.HttpContext.Current.Session["SRIDforSRDetailsPost"].ToString();
int SRID = Convert.ToInt32(System.Web.HttpContext.Current.Session["SRIDforSRDetailsPost"]);
if (Request.Form["approvesr"] != null)
{
if (srn.ApproveTokenUpdateAction(SRID, mid) == 1)
{
srn.UI_InsertAssignedStatus(SRID, mid, obj.Comments);
tokenObj.UI_sendMailToUser_AfterApproved(SRID.ToString());
tokenObj.UI_sendMailToAdmin_AfterApproved(SRID.ToString());
}
else
{
TempData["ApproveError"] = "Your time Limit to approve this SR has been crossed so now it is with 2nd Approver";
}
SRDetails();
}
if (Request.Form["rejectsr"] != null)
{
if (obj.Comments != null)
{
if (srn.RejectTokenUpdateAction(SRID, mid) == 1)
{
srn.UI_InsertAssignedStatus(SRID, mid, obj.Comments);
tokenObj.UI_sendMailToUser_AfterReject(SRID.ToString());
SRDetails();
}
else
{
SRDetails();
TempData["ApproveError"] = "Your time Limit to reject this SR has been crossed so now it is with 2nd Approver";
}
}
SRDetails();
}
}
catch (Exception e)
{
Log.CreateLog(e);
}
return(View());
}
public JsonResult Upload()
{
bool flag = true;
string responseMessage = string.Empty;
if (Request.Files.Count > 0)
{
HttpPostedFileBase file = Request.Files[0];
//add more conditions like file type, file size etc as per your need.
if (file != null && file.ContentLength > 0 && (Path.GetExtension(file.FileName).ToLower() == ".xlsx" || Path.GetExtension(file.FileName).ToLower() == ".xls"))
{
string Uploadpath = Server.MapPath("~/Upload/");
if (!Directory.Exists(Uploadpath))
{
Directory.CreateDirectory(Uploadpath);
}
try
{
string fileName = Path.GetFileName(file.FileName);
string filePath = Path.Combine(Uploadpath, fileName);
file.SaveAs(filePath);
SRNumber srn = new SRNumber();
int retVal = srn.UploadAttachment(fileName, filePath);
if (retVal == 1)
{
flag = true;
responseMessage = "Upload Successful.";
}
}
catch (Exception ex)
{
flag = false;
responseMessage = "Upload Failed with error: " + ex.Message;
}
}
else
{
flag = false;
responseMessage = "File is invalid. Please upload file with .xlsx/.xls";
}
}
else
{
flag = false;
responseMessage = "File Upload has no file.";
}
return(Json(new { success = flag, responseMessage = responseMessage }, JsonRequestBehavior.AllowGet));
}
public JsonResult GetTagAssetMID(int AssetID)
{
SRNumber srn = new SRNumber();
IEnumerable <SRNumber.EmployeeData> employees = srn.GetTagAssetMID(AssetID);
if (employees.Count() != 0)
{
return(Json(employees, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public JsonResult UnTagAssetMID(int MID, int AssetID)
{
SRNumber srn = new SRNumber();
int retVal = srn.UnTagAssetMID(MID, AssetID);
if (retVal == 1)
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public IEnumerable <object> findExistingSR(ExistingSR esr, string Role, string MID)
{
string ServiceRequest_ID = esr.SR_Number;
int? SRID;
if (ServiceRequest_ID == null)
{
SRID = null;
}
else
{
SRID = Convert.ToInt32(ServiceRequest_ID.TrimStart('S', 'R', '0'));
}
DateTime?FromDate;
if (esr.SR_Ticket_From == DateTime.MinValue)
{
FromDate = null;
}
else
{
FromDate = esr.SR_Ticket_From;
}
DateTime?TillDate;
if (esr.SR_Ticket_To == DateTime.MinValue)
{
TillDate = null;
}
else
{
TillDate = esr.SR_Ticket_To;
}
int?Status = 0;
if (esr.Status == 0)
{
Status = null;
}
else
{
Status = esr.Status;
}
SRNumber assetObj = new SRNumber();
return(assetObj.findExistingSR(SRID, FromDate, TillDate, Status, Role, MID));
}
public ActionResult SRDetails(ApproverSRDetails obj)
{
string mid = System.Web.HttpContext.Current.Session["id"].ToString();
try
{
SRNumber srn = new SRNumber();
int userID = Convert.ToInt32(srn.getUserId(mid));
int RoleID = Convert.ToInt32(srn.generateRoleID(userID));
int count = Convert.ToInt32(System.Web.HttpContext.Current.Session["CountforSRDetails"]);
Session["CountforSRDetails"] = count;
int SRID = Convert.ToInt32(System.Web.HttpContext.Current.Session["SRIDforSRDetailsPost"]);
int retValforSRS = srn.InsertNextSRStatus(SRID, userID, RoleID, obj.Comments, obj.selectStatus);
if (retValforSRS == 1)
{
SRDetails();
if (obj.selectStatus == "Closed")
{
string Subject = "SR000000" + SRID + " " + "-Resolved";
string mailId = srn.SRCreatorMail(SRID);
string mailBody = "Hi," + "<br/> The SR000000" + SRID + " " + "has been closed by Admin team. Please visit SR for any further concern";
SendMail(Subject, mailBody, mailId);
}
TempData["AlertMessage"] = "Ticket is now " + obj.selectStatus;
}
else if (retValforSRS == 2)
{
SRDetails();
TempData["AlertMessage"] = "Service Ticket is already in Progress !!!";
}
else
{
//return Content("<script> alert('Please make the Service request in Progress before closing it')</script>");
SRDetails();
TempData["AlertMessage"] = "Please make the Service request in Progress before closing it";
}
}
catch (Exception e)
{
Log.CreateLog(e.InnerException);
}
return(View());
}
public JsonResult CheckAssetMIDMapping(int MID, int AssetID)
{
SRNumber srn = new SRNumber();
string retVal = srn.CheckAssetMIDMapping(MID, AssetID);
if (retVal != "Exists" && retVal != null)
{
return(Json(retVal, JsonRequestBehavior.AllowGet));
}
else if (retVal == "Exists")
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetRequestedMID(int SRID)
{
SRNumber srn = new SRNumber();
int retVal = srn.CheckSRIDforMID(SRID);
if (retVal == 1)
{
IEnumerable <SRNumber.EmployeeData> employeeDatas = srn.GetRequestedMID(SRID);
if (employeeDatas.Count() != 0)
{
return(Json(employeeDatas, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(true, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SRDetails(ServiceRequest obj)
{
string mid = System.Web.HttpContext.Current.Session["id"].ToString();
try
{
SRNumber srn = new SRNumber();
int userID = Convert.ToInt32(srn.getUserId(mid));
int RoleID = Convert.ToInt32(srn.generateRoleID(userID));
int SRID = Convert.ToInt32(System.Web.HttpContext.Current.Session["SRIDforSRDetailsPost"]);
int statusID = Convert.ToInt32(srn.generateStatusID(SRID));
int count = Convert.ToInt32(System.Web.HttpContext.Current.Session["CountforSRDetails"]);
Session["CountforSRDetails"] = count;
SRDetails();
if (Request.Form["cancelsr"] != null)
{
foreach (var SRDetails in ViewBag.SRDetails)
{
string CurrentSRID = SRDetails.ServiceRequest_ID;
CurrentSRID = CurrentSRID.TrimStart('S', 'R', '0');
DateTime CurrentLastModifiedTimeStamp = SRDetails.LastModifiedTimeStamp;
int retValforSRS1 = srn.CancelSR(CurrentSRID, userID, RoleID, obj.Comments, CurrentLastModifiedTimeStamp);
}
SRDetails();
}
}
catch (Exception e)
{
Log.CreateLog(e);
}
return(View());
}
public IEnumerable <object> getPurpose()
{
SRNumber assetObj = new SRNumber();
return(assetObj.getPurpose());
}
public IEnumerable <object> fetchTicketHistory(int SRID)
{
SRNumber assetObj = new SRNumber();
return(assetObj.getTicketHistory(SRID));
}
public IEnumerable <object> fetchSRDetails(int SRID)
{
SRNumber assetObj = new SRNumber();
return(assetObj.getSRDetails(SRID));
}
public IEnumerable <SRNumber.GetAttachment> getAttachments(int SRID)
{
SRNumber srn = new SRNumber();
return(srn.GetAttachments(SRID));
}
public SelectList getStatuses()
{
SRNumber srn = new SRNumber();
return(srn.getStatus());
}
public IEnumerable <object> getExistingSR(string MID)
{
SRNumber assetObj = new SRNumber();
return(assetObj.getExistingSR(MID));
}
public SelectList getStatus()
{
SRNumber assetObj = new SRNumber();
return(assetObj.getStatus());
}
public IEnumerable <object> getExistingSR()
{
SRNumber assetObj = new SRNumber();
return(assetObj.getApproverExistingSR());
}
public IEnumerable <object> getSoftwares()
{
SRNumber assetObj = new SRNumber(); //business Layer object
return(assetObj.GetSoftwares());
}
