public ActionResult Login(LoginModel model, string returnUrl)
{
if (ModelState.IsValid)
{
mSellerDemoLiveEntities context = new mSellerDemoLiveEntities();
var ddd = context.tblAdminLogins.ToList();
var userDetail = (from m in context.tblAdminLogins where m.LoginName == model.UserName && m.LoginPassword == model.Password select m).FirstOrDefault();
if (userDetail != null)
{
//GnSession.CustomerName = userDetail.LoginName;
//GnSession.CustomerId =Convert.ToInt16(userDetail.Loginid);
FormsAuthentication.SetAuthCookie(userDetail.LoginName, model.RememberMe);
if (string.IsNullOrEmpty(returnUrl))
{
return(RedirectToAction("Index", "Dashboard"));
}
else
{
return(RedirectToLocal(returnUrl));
}
}
}
// If we got this far, something failed, redisplay form
ModelState.AddModelError("", "The user name or password provided is incorrect.");
return(View(model));
}
public ActionResult GetOrderDetail(string BatchNo = "", string OrderId = "", string companyname = "", string repid = "")
{
mSellerDemoLiveEntities db = new mSellerDemoLiveEntities();
List <SubOrderLog> OrderLogList = new List <SubOrderLog>();
if (string.IsNullOrEmpty(BatchNo))
{
OrderLogList = (from m in db.SubOrderLogs select m).ToList();
}
else
{
OrderLogList = (from m in db.SubOrderLogs where m.BatchNo == BatchNo && m.OrderId == OrderId select m).ToList();
}
ViewBag.BatchNo = BatchNo;
ViewBag.Orderid = OrderId;
ViewBag.companyname = companyname;
ViewBag.repid = repid;
//By Vishal
ViewBag.company = db.tblCompanies.Select(cc => new { cc.CompanyId, cc.Name })
.ToList()
.Select(c =>
new SelectListItem()
{
Text = c.Name, Value = c.CompanyId.ToString()
});
return(View(OrderLogList));
}
public ActionResult OrderLog(string BatchNo = "", string OrderId = "")
{
mSellerDemoLiveEntities db = new mSellerDemoLiveEntities();
List <OrderLog> OrderLogList = new List <OrderLog>();
if (string.IsNullOrEmpty(BatchNo))
{
OrderLogList = (from m in db.OrderLogs select m).ToList();
}
else
{
OrderLogList = (from m in db.OrderLogs where m.BatchNo == BatchNo && m.OrderID == OrderId select m).ToList();
}
// by vishal on 13july 18
OrderLogList = (from m in db.OrderLogs where (m.BatchNo == BatchNo) && m.OrderID == OrderId select m).ToList();
ViewBag.BatchNo = BatchNo;
ViewBag.Companey = "";
ViewBag.Repid = "";
if (OrderLogList.Count > 0)
{
ViewBag.Companey = OrderLogList[0].Company;
ViewBag.Repid = OrderLogList[0].EmployeeID;
}
return(View(OrderLogList));
}
public JsonResult GetRepid(string repid = "")
{
mSellerDemoLiveEntities db = new mSellerDemoLiveEntities();
var conpmayId = db.tblCompanies.Single(c => c.CompanyCode == repid).CompanyId;
var result = (from m in db.TblUsers where m.CompanyId == conpmayId && m.IsActive == true && m.IsDeleted == false select new SelectListItem()
{
Text = m.FirstName, Value = m.Rep_Id
}).ToList(); // new SelectList(db.TblUsers, "Account", "Account");
return(Json(result, JsonRequestBehavior.AllowGet));
}
public ActionResult GetOrderList2(string Batchno = "")
{
mSellerDemoLiveEntities context = new mSellerDemoLiveEntities();
con = new SqlConnection(context.Database.Connection.ConnectionString);
string query = "select * from(SELECT ISNULL(OrderLog.Company, tblSaveOrder.Company)as Company,ISNULL(OrderLog.EmployeeID, tblSaveOrder.EmployeeID) as EmployeeID, ISNULL(tblsaveorder.orderid, OrderLog.OrderID)as orderid,ISNULL(OrderLog.OrderDate,tblsaveorder.Order_Date) as Order_Date,OrderLog.BatchNo,tblsaveorder.CreatedDate as SaveTransaction, OrderLog.CreatedDate as TransactionSend,ISNULL(tblsaveorder.CreatedDate,OrderLog.CreatedDate) as createdate,ISNULL(tblsaveorder.customer_Code,OrderLog.customerid) as custcode FROM tblsaveorder FULL OUTER JOIN OrderLog ON tblsaveorder.orderid = OrderLog.OrderID) as p where p.Batchno='" + Batchno + "' or p.orderid='" + Batchno + "'";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
da.Dispose();
List <OrderList> lstOrder = new List <OrderList>();
foreach (DataRow item in dt.Rows)
{
OrderList temp = new OrderList();
temp.BatchNo = item[4].ToString();
temp.Company = item[0].ToString();
temp.EmployeeID = item[1].ToString() + "- (" + item[8].ToString() + ")";
temp.OrderDate = item[3].ToString();
temp.OrderID = item[2].ToString();
temp.SaveTransaction = item[5].ToString();
temp.SendTransaction = item[6].ToString();
lstOrder.Add(temp);
}
int no_of_rows = 0;
if (dt.Rows != null)
{
no_of_rows = dt.Rows.Count;
}
ViewBag.noOfOrder = no_of_rows;
mSellerDemoLiveEntities db = new mSellerDemoLiveEntities();
ViewBag.company = new SelectList(db.tblCompanies.Where(c => c.isActive)
.Select(ccc => new { ccc.CompanyId, ccc.Name, ccc.CompanyCode }).ToList()
.Select(cc => new { cc.CompanyCode, Name = cc.Name + " (" + cc.CompanyCode + ")" }),
"CompanyCode", "Name");
return(View("OrderIDList", lstOrder));
}
public ActionResult Index()
{
db = new mSellerDemoLiveEntities();
var dic = db.tblCompanies
.Where(com =>
!com.isDeleted)
.Select(co => new { co.CompanyCode, co.Name })
.ToDictionary(c => int.Parse(c.CompanyCode), c => c.Name);
ViewBag.Companies = dic;
var companies = geodb.GeoDataProcessedCompanies
.OrderByDescending(c2 => c2.IsProcessing)
.ThenByDescending(c2 => c2.EnableProcessing)
.ThenBy(c2 => c2.CompanyCode)
;
return(View(companies));
}
public ActionResult GetDeviceLog(string CompanyCode = "")
{
mSellerDemoLiveEntities context = new mSellerDemoLiveEntities();
con = new SqlConnection(context.Database.Connection.ConnectionString);
string query = "select * from FullUPdateLog where DATEPART(month,LogDate)=" + DateTime.Now.Day + " and DATEPART(year,LogDate)=" + DateTime.Now.Year + " and DATEPART(day,LogDate)=" + DateTime.Now.Month;
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
List <FullUPdateLog> obj = new List <FullUPdateLog>();
foreach (DataRow item in dt.Rows)
{
FullUPdateLog newobj = new FullUPdateLog();
newobj.CompanyName = item[1].ToString();
newobj.LicenseKey = item[2].ToString();
newobj.DeviceId = item[3].ToString();
newobj.LicenseKey = item[4].ToString();
obj.Add(newobj);
}
var count = dt.Rows.Count;
dt.Rows.Clear();
DateTime day5 = DateTime.Now.AddDays(-1);
DateTime day4 = DateTime.Now.AddDays(-2);
DateTime day3 = DateTime.Now.AddDays(-3);
DateTime day2 = DateTime.Now.AddDays(-4);
DateTime day1 = DateTime.Now.AddDays(-5);
string query5 = "select * from FullUPdateLog where DATEPART(month,LogDate)=" + day5.Day + " and DATEPART(year,LogDate)=" + day5.Year + " and DATEPART(day,LogDate)=" + day5.Month;
string query4 = "select * from FullUPdateLog where DATEPART(month,LogDate)=" + day4.Day + " and DATEPART(year,LogDate)=" + day4.Year + " and DATEPART(day,LogDate)=" + day4.Month;
string query3 = "select * from FullUPdateLog where DATEPART(month,LogDate)=" + day3.Day + " and DATEPART(year,LogDate)=" + day3.Year + " and DATEPART(day,LogDate)=" + day3.Month;
string query2 = "select * from FullUPdateLog where DATEPART(month,LogDate)=" + day2.Day + " and DATEPART(year,LogDate)=" + day2.Year + " and DATEPART(day,LogDate)=" + day2.Month;
string query1 = "select * from FullUPdateLog where DATEPART(month,LogDate)=" + day1.Day + " and DATEPART(year,LogDate)=" + day1.Year + " and DATEPART(day,LogDate)=" + day1.Month;
SqlCommand cmd5 = new SqlCommand(query5, con);
con.Open();
DataTable dt5 = new DataTable();
SqlDataAdapter da5 = new SqlDataAdapter(cmd5);
da5.Fill(dt);
con.Close();
var count5 = dt.Rows.Count;
dt.Rows.Clear();
SqlCommand cmd1 = new SqlCommand(query1, con);
con.Open();
DataTable dt1 = new DataTable();
SqlDataAdapter da1 = new SqlDataAdapter(cmd1);
da1.Fill(dt);
con.Close();
var count1 = dt.Rows.Count;
dt.Rows.Clear();
SqlCommand cmd2 = new SqlCommand(query2, con);
con.Open();
DataTable dt2 = new DataTable();
SqlDataAdapter da2 = new SqlDataAdapter(cmd2);
da2.Fill(dt);
con.Close();
var count2 = dt.Rows.Count;
dt.Rows.Clear();
SqlCommand cmd3 = new SqlCommand(query3, con);
con.Open();
DataTable dt3 = new DataTable();
SqlDataAdapter da3 = new SqlDataAdapter(cmd3);
da3.Fill(dt);
con.Close();
var count3 = dt.Rows.Count;
dt.Rows.Clear();
SqlCommand cmd4 = new SqlCommand(query4, con);
con.Open();
DataTable dt4 = new DataTable();
SqlDataAdapter da4 = new SqlDataAdapter(cmd4);
da4.Fill(dt);
con.Close();
var count4 = dt.Rows.Count;
dt.Rows.Clear();
ViewBag.Total = count;
ViewBag.Total1 = count1;
ViewBag.Total2 = count2;
ViewBag.Total3 = count3;
ViewBag.Total4 = count4;
ViewBag.Total5 = count5;
//SqlCommand cmd5 = new SqlCommand(query5, con);
//con.Open();
//DataTable dt5 = new DataTable();
//SqlDataAdapter da5 = new SqlDataAdapter(cmd5);
//da.Fill(dt);
//con.Close();
//var count5 = dt.Rows.Count;
return(View(obj));
// string[] formats = { "dd/MM/yyyy" };
// mSellerDemoLiveEntities db = new mSellerDemoLiveEntities();
// DateTime fromdate_1 = DateTime.Now;
// string fromdate_1_ = fromdate_1.ToString("dd/MM/yyyy");
// DateTime fromdate1 = DateTime.ParseExact(fromdate_1_, formats, new CultureInfo("en"), DateTimeStyles.no
//);
// DateTime fromdate_2 = DateTime.Now.AddDays(-1);
// string fromdate_2_ = fromdate_1.ToShortDateString();
// var fromdate2 = DateTime.ParseExact(fromdate_2_, formats, new CultureInfo("en-US"), DateTimeStyles.None);
// DateTime fromdate_3 = DateTime.Now.AddDays(-2);
// string fromdate_3_ = fromdate_1.ToShortDateString();
// var fromdate3 = DateTime.ParseExact(fromdate_3_, formats, new CultureInfo("en-US"), DateTimeStyles.None);
// DateTime fromdate_4 = DateTime.Now.AddDays(-3);
// string fromdate_4_ = fromdate_1.ToShortDateString();
// var fromdate4 = DateTime.ParseExact(fromdate_4_, formats, new CultureInfo("en-US"), DateTimeStyles.None);
// DateTime fromdate_5 = DateTime.Now.AddDays(-4);
// string fromdate_5_ = fromdate_1.ToShortDateString();
// var fromdate5 = DateTime.ParseExact(fromdate_5_, formats, new CultureInfo("en-US"), DateTimeStyles.None);
// DateTime fromdate_6 = DateTime.Now.AddDays(-5);
// string fromdate_6_ = fromdate_1.ToShortDateString();
// var fromdate6 = DateTime.ParseExact(fromdate_6_, formats, new CultureInfo("en-US"), DateTimeStyles.None);
// ViewBag.Total=0;
// if (string.IsNullOrEmpty(CompanyCode))
// {
// var Loglist = (from m in db.FullUPdateLogs where m.LogDate >= fromdate1 && m.LicenseKey != "59f96ef7-52ea-4048-bf83-0598f3f7ff6d" orderby m.LogDate select m).ToList();
// var Loglist1 = (from m in db.FullUPdateLogs where m.LogDate >= fromdate1 && m.LogDate < fromdate_2 && m.LicenseKey != "59f96ef7-52ea-4048-bf83-0598f3f7ff6d" orderby m.LogDate select m).ToList();
// var Loglist2 = (from m in db.FullUPdateLogs where m.LogDate >= fromdate2 && m.LogDate < fromdate_3 && m.LicenseKey != "59f96ef7-52ea-4048-bf83-0598f3f7ff6d" orderby m.LogDate select m).ToList();
// var Loglist3 = (from m in db.FullUPdateLogs where m.LogDate >= fromdate3 && m.LogDate < fromdate_4 && m.LicenseKey != "59f96ef7-52ea-4048-bf83-0598f3f7ff6d" orderby m.LogDate select m).ToList();
// var Loglist4 = (from m in db.FullUPdateLogs where m.LogDate >= fromdate4 && m.LogDate < fromdate_5 && m.LicenseKey != "59f96ef7-52ea-4048-bf83-0598f3f7ff6d" orderby m.LogDate select m).ToList();
// var Loglist5 = (from m in db.FullUPdateLogs where m.LogDate >= fromdate5 && m.LogDate < fromdate_6 && m.LicenseKey != "59f96ef7-52ea-4048-bf83-0598f3f7ff6d" orderby m.LogDate select m).ToList();
// ViewBag.Total = Loglist.Count;
// ViewBag.Total1 = Loglist1.Count;
// ViewBag.Total2 = Loglist2.Count;
// ViewBag.Total3 = Loglist3.Count;
// ViewBag.Total4= Loglist4.Count;
// ViewBag.Total5 = Loglist5.Count;
// return View(Loglist);
// }
// return View();
}
public ActionResult GetOrderList(DateTime?fromdate, DateTime?Todate, string Type = "", int option = 0, string company = "", string repid = "")
{
mSellerDemoLiveEntities context = new mSellerDemoLiveEntities();
con = new SqlConnection(context.Database.Connection.ConnectionString);
string query = " select * from( SELECT ISNULL(OrderLog.Company, tblSaveOrder.Company)as Company,ISNULL(OrderLog.EmployeeID, tblSaveOrder.EmployeeID) as EmployeeID , ISNULL(tblsaveorder.orderid, OrderLog.OrderID)as orderid,ISNULL(OrderLog.OrderDate,tblsaveorder.Order_Date) as Order_Date, OrderLog.BatchNo,tblsaveorder.CreatedDate as SaveTransaction, OrderLog.CreatedDate as TransactionSend,ISNULL(OrderLog.CreatedDate,tblsaveorder.CreatedDate) as createdate,ISNULL(OrderLog.customerid,tblsaveorder.customer_Code) as custcode FROM tblsaveorder FULL OUTER JOIN OrderLog ON tblsaveorder.orderid = OrderLog.OrderID) as p ";
string filter = "";
if (!string.IsNullOrEmpty(Type))
{
if (Type == "SelectedDate")
{
if (fromdate != null)
{
string fromdate_ = fromdate.Value.ToString("MM/dd/yyyy");
filter = "p.createdate>='" + fromdate_ + "' ";
}
if (Todate != null)
{
string Todate_ = Todate.Value.ToString("MM/dd/yyyy hh:mm:ss");
filter = string.IsNullOrWhiteSpace(filter) ? " p.createdate<='" + Todate_ + "' " : filter + " and p.createdate<='" + Todate_ + "' ";
}
}
if (Type == "Defineddate")
{
if (option == 1)
{
filter = " p.createdate>='" + DateTime.Now.ToString("MM/dd/yyyy") + "' ";
}
else if (option == 2)
{
filter = " p.createdate>='" + DateTime.Now.AddDays(-3).ToString("MM/dd/yyyy") + "' ";
}
else if (option == 3)
{
filter = " p.createdate>='" + DateTime.Now.AddDays(-7).ToString("MM/dd/yyyy") + "' ";
}
}
}
else
{
return(RedirectToAction("OrderIDList"));
}
string filter_ = "";
if (!string.IsNullOrWhiteSpace(filter))
{
if (company != "")
{
filter_ = " and p.Company=" + company;
if (repid != "" && repid != "0")
{
filter_ = filter_ + " and p.EmployeeID=" + repid;
}
}
filter = " where " + filter + filter_ + " order by p.TransactionSend desc";
query = query + filter;
}
else
{
if (company != "")
{
filter_ = " where p.Company=" + company;
if (repid != "" && repid != "0")
{
filter_ = filter_ + " and p.EmployeeID=" + repid;
}
}
filter = filter_ + " order by p.TransactionSend desc";
query = query + filter;
}
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
DataTable dt = new DataTable();
// create data adapter
SqlDataAdapter da = new SqlDataAdapter(cmd);
// this will query your database and return the result to your datatable
da.Fill(dt);
con.Close();
da.Dispose();
List <OrderList> lstOrder = new List <OrderList>();
foreach (DataRow item in dt.Rows)
{
OrderList temp = new OrderList();
temp.BatchNo = item[4].ToString();
temp.Company = item[0].ToString();
temp.EmployeeID = item[1].ToString() + "- (" + item[8].ToString() + ")";;
temp.OrderDate = item[3].ToString();
temp.OrderID = item[2].ToString();
temp.SaveTransaction = item[5].ToString();
temp.SendTransaction = item[6].ToString();
lstOrder.Add(temp);
}
int no_of_rows = 0;
if (dt.Rows != null)
{
no_of_rows = dt.Rows.Count;
}
ViewBag.noOfOrder = no_of_rows;
mSellerDemoLiveEntities db = new mSellerDemoLiveEntities();
ViewBag.company = new SelectList(db.tblCompanies.Where(c => c.isActive)
.Select(ccc => new { ccc.CompanyId, ccc.Name, ccc.CompanyCode }).ToList()
.Select(cc => new { cc.CompanyCode, Name = cc.Name + " (" + cc.CompanyCode + ")" }),
"CompanyCode", "Name");
return(View("OrderIDList", lstOrder));
}
