public ActionResult Register(user2 e)
{
DBCTX DC = new DBCTX();
DC.user.Add(e);
DC.SaveChanges();
return(RedirectToAction("login"));
}
public JsonResult gdata1(string aData)
{
List <SHEET1> STLIST = new List <SHEET1>();
using (DBCTX FC = new DBCTX())
{
STLIST = FC.SHEET1.Where(A => A.PARTI.Equals(aData)).ToList();
}
return(new JsonResult {
Data = STLIST, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult gdata2(string aData)
{
List <MAINPOPU> STLIST = new List <MAINPOPU>();
using (DBCTX FC = new DBCTX())
{
STLIST = FC.MAINPOPU.Where(A => A.ENS.Equals(aData)).ToList();
}
return(new JsonResult {
Data = STLIST, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult allrec()
{
List <PMR> STLIST = new List <PMR>();
using (DBCTX FC = new DBCTX())
{
STLIST = FC.PMR.ToList();
}
return(new JsonResult {
Data = STLIST, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult filrec(DateTime sdt, DateTime edt)
{
List <PMR> STLIST = new List <PMR>();
using (DBCTX FC = new DBCTX())
{
STLIST = FC.PMR.Where(A => A.CDATI >= sdt && A.CDATI <= edt).ToList();
}
return(new JsonResult {
Data = STLIST, JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public int dpl1(string aData)
{
int msg;
List <TABLE2> STLIST1 = new List <TABLE2>();
using (DBCTX FC = new DBCTX())
{
STLIST1 = FC.STOCK.Where(a => a.PARTI.Equals(aData)).ToList();
var cn = STLIST1.Count();
msg = cn;
}
return(msg);
}
public ActionResult fil_pmr(string sdt, string edt)
{
List <PMR> STLIST = new List <PMR>();
DateTime sdt1 = Convert.ToDateTime(sdt);
DateTime edt1 = Convert.ToDateTime(edt);
TimeSpan ts = new TimeSpan(23, 59, 59);
edt1 = edt1.Add(ts);
using (DBCTX FC = new DBCTX())
{
STLIST = FC.PMR.Where(A => A.CDATI >= sdt1 && A.CDATI <= edt1).ToList();
}
return(View(STLIST));
}
public ActionResult login(user2 L, string ReturnUrl = "")
{
using (DBCTX DC1 = new DBCTX())
{
var user = DC1.user.Where(a => a.uid.Equals(L.uid) && a.pass.Equals(L.pass)).FirstOrDefault();
if (user != null)
{
FormsAuthentication.SetAuthCookie(user.fname, false);
if (Url.IsLocalUrl(ReturnUrl))
{
return(Redirect(ReturnUrl));
}
else
{
return(RedirectToAction("AfterLogin", "Home"));
}
}
}
return(View());
}
public Posts(DBCTX context)
{
_context = context;
}
public Articles(DBCTX context)
{
_context = context;
}
public UserAlbum(DBCTX context)
{
_context = context;
}
public File(DBCTX context)
{
_context = context;
}
public User(DBCTX context)
{
_context = context;
}
public login(DBCTX context)
{
_context = context;
}
public ActionResult exp1_pmr(string ens)
{
var wb = new XLWorkbook();
var ws = wb.Worksheets.Add("PMR");
ws.Cell(1, 1).Value = "Customer";
ws.Cell(1, 2).Value = "Issue Type";
ws.Cell(1, 3).Value = "Issue Open Date";
ws.Cell(1, 4).Value = "Complaint / Service No";
ws.Cell(1, 5).Value = "Site Id";
ws.Cell(1, 6).Value = "Site Name";
ws.Cell(1, 7).Value = "District";
ws.Cell(1, 8).Value = "State";
ws.Cell(1, 9).Value = "Issue Category";
ws.Cell(1, 10).Value = "Engine No";
ws.Cell(1, 11).Value = "Model";
ws.Cell(1, 12).Value = "KVA";
ws.Cell(1, 13).Value = "DOI";
ws.Cell(1, 14).Value = "DG SET NO";
ws.Cell(1, 15).Value = "Alt. Make";
ws.Cell(1, 16).Value = "Alt. Sr. No";
ws.Cell(1, 17).Value = "Battery Sr. No";
ws.Cell(1, 18).Value = "HMR";
ws.Cell(1, 19).Value = "Issue Nature";
ws.Cell(1, 20).Value = "Serverity";
ws.Cell(1, 21).Value = "Failure Reason";
ws.Cell(1, 22).Value = "Issue Status";
ws.Cell(1, 23).Value = "Issue Closed Date";
ws.Cell(1, 24).Value = "Warranty Status";
ws.Cell(1, 25).Value = "Action Taken";
ws.Cell(1, 26).Value = "Material Used";
ws.Cell(1, 27).Value = "Dealer Code";
ws.Cell(1, 28).Value = "Technician Visited";
ws.Cell(1, 29).Value = "OEA";
ws.Cell(1, 30).Value = "AMC Status";
ws.Cell(1, 31).Value = "TTR";
ws.Cell(1, 32).Value = "SLA Status";
ws.Cell(1, 33).Value = "Time Slot";
ws.Cell(1, 34).Value = "Reason Of SLA";
ws.Cell(1, 35).Value = "Remarks";
List <PMR> STLIST = new List <PMR>();
using (DBCTX FC = new DBCTX())
{
STLIST = FC.PMR.Where(A => A.ENGINE_No.Equals(ens)).ToList();
}
GridView gv = new GridView();
gv.DataSource = STLIST;
gv.DataBind();
for (int I = 0; I < gv.Rows.Count; I++)
{
ws.Cell(I + 2, 1).Value = gv.Rows[I].Cells[10].Text;
ws.Cell(I + 2, 2).Value = gv.Rows[I].Cells[5].Text;
ws.Cell(I + 2, 3).Value = gv.Rows[I].Cells[4].Text;
ws.Cell(I + 2, 4).Value = gv.Rows[I].Cells[11].Text;
ws.Cell(I + 2, 5).Value = gv.Rows[I].Cells[1].Text;
ws.Cell(I + 2, 6).Value = gv.Rows[I].Cells[2].Text;
ws.Cell(I + 2, 7).Value = gv.Rows[I].Cells[13].Text;
ws.Cell(I + 2, 8).Value = gv.Rows[I].Cells[14].Text;
ws.Cell(I + 2, 9).Value = gv.Rows[I].Cells[15].Text;
ws.Cell(I + 2, 10).Value = gv.Rows[I].Cells[3].Text;
ws.Cell(I + 2, 11).Value = gv.Rows[I].Cells[16].Text;
ws.Cell(I + 2, 12).Value = gv.Rows[I].Cells[34].Text;
ws.Cell(I + 2, 13).Value = gv.Rows[I].Cells[17].Text;
ws.Cell(I + 2, 14).Value = gv.Rows[I].Cells[18].Text;
ws.Cell(I + 2, 15).Value = gv.Rows[I].Cells[19].Text;
ws.Cell(I + 2, 16).Value = gv.Rows[I].Cells[20].Text;
ws.Cell(I + 2, 17).Value = gv.Rows[I].Cells[21].Text;
ws.Cell(I + 2, 18).Value = gv.Rows[I].Cells[6].Text;
ws.Cell(I + 2, 19).Value = gv.Rows[I].Cells[22].Text;
ws.Cell(I + 2, 20).Value = gv.Rows[I].Cells[23].Text;
ws.Cell(I + 2, 21).Value = gv.Rows[I].Cells[24].Text;
ws.Cell(I + 2, 22).Value = gv.Rows[I].Cells[25].Text;
ws.Cell(I + 2, 23).Value = gv.Rows[I].Cells[12].Text;
ws.Cell(I + 2, 24).Value = gv.Rows[I].Cells[26].Text;
ws.Cell(I + 2, 25).Value = gv.Rows[I].Cells[27].Text;
ws.Cell(I + 2, 26).Value = gv.Rows[I].Cells[9].Text;
ws.Cell(I + 2, 27).Value = gv.Rows[I].Cells[36].Text;
ws.Cell(I + 2, 28).Value = gv.Rows[I].Cells[8].Text;
ws.Cell(I + 2, 29).Value = gv.Rows[I].Cells[28].Text;
ws.Cell(I + 2, 30).Value = gv.Rows[I].Cells[29].Text;
ws.Cell(I + 2, 31).Value = gv.Rows[I].Cells[30].Text;
ws.Cell(I + 2, 32).Value = gv.Rows[I].Cells[31].Text;
ws.Cell(I + 2, 33).Value = gv.Rows[I].Cells[32].Text;
ws.Cell(I + 2, 34).Value = gv.Rows[I].Cells[33].Text;
ws.Cell(I + 2, 35).Value = gv.Rows[I].Cells[39].Text;
}
ws.Range("c2", "c" + ws.RangeUsed().RowCount()).Style.NumberFormat.SetFormat("dd-MMM-yyyy hh:mm:ss");
ws.Range("m2", "m" + ws.RangeUsed().RowCount()).Style.NumberFormat.SetFormat("dd-MMM-yyyy hh:mm:ss");
ws.Range("w2", "w" + ws.RangeUsed().RowCount()).Style.NumberFormat.SetFormat("dd-MMM-yyyy hh:mm:ss");
ws.Range("j2", "j" + ws.RangeUsed().RowCount()).Style.NumberFormat.SetFormat("#");
ws.Columns().AdjustToContents();
ws.SheetView.FreezeRows(1);
ClosedXML.Excel.IXLRange range = ws.RangeUsed();
string RCNT = "ai" + range.RowCount();
ws.Range("a1", RCNT).Style.Border.TopBorder = XLBorderStyleValues.Thin;
ws.Range("a1", RCNT).Style.Border.RightBorder = XLBorderStyleValues.Thin;
ws.Range("a1", RCNT).Style.Border.LeftBorder = XLBorderStyleValues.Thin;
ws.Range("a1", RCNT).Style.Border.BottomBorder = XLBorderStyleValues.Thin;
ws.Range("a1", "ai1").Style.Fill.BackgroundColor = XLColor.Turquoise;
Response.Clear();
Response.Buffer = true;
Response.Charset = "";
Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
Response.AddHeader("content-disposition", "attachment;filename=PMR.xlsx");
using (MemoryStream MyMemoryStream = new MemoryStream())
{
wb.SaveAs(MyMemoryStream);
MyMemoryStream.WriteTo(Response.OutputStream);
Response.Flush();
Response.End();
}
return(Content("Data added successfully"));
}
