public ActionResult LogOut()
{
try
{
if (Session["LoginHistoryID"] != null)
{
#region SEC_LoginHistory Update
using (DB_A157D8_AnjaliMISEntities1 db = new DB_A157D8_AnjaliMISEntities1())
{
Int32 id = Convert.ToInt16(Session["LoginHistoryID"].ToString());
SEC_LoginHistory sEC_LoginHistory = db.SEC_LoginHistory.Find(id);
db.Entry(sEC_LoginHistory).State = EntityState.Modified;
sEC_LoginHistory.Modified = DateTime.Now;
sEC_LoginHistory.LogoutTime = DateTime.Now;
sEC_LoginHistory.Remarls = "Logout..";
db.SaveChanges();
}
#endregion SEC_LoginHistory Update
}
}
catch (Exception ex)
{
}
FormsAuthentication.SignOut();
Session.Clear();
Session.Abandon(); // it will clear the session at the end of request
return(RedirectToAction("index"));
}
protected void btnShow_Click(object sender, EventArgs e)
{
if (ddlPurchaseOrderID.SelectedIndex > 0)
{
SqlInt32 PurchaseOrderID = SqlInt32.Null;
DataTable dtPO = new DataTable();
List <POPrintReportViewModal> _POPrintReportViewModal = new List <POPrintReportViewModal>();
if (ddlPurchaseOrderID.SelectedIndex > 0)
{
PurchaseOrderID = Convert.ToInt32(ddlPurchaseOrderID.SelectedValue);
}
using (DB_A157D8_AnjaliMISEntities1 db = new DB_A157D8_AnjaliMISEntities1())
{
try
{
var sql = "exec PP_INV_PurchaseOrder_SelectForPrint @PurchaseOrderID";
List <SqlParameter> parameterList = new List <SqlParameter>();
parameterList.Add(new SqlParameter("@PurchaseOrderID", PurchaseOrderID));
SqlParameter[] parameters = parameterList.ToArray();
dtPO = CommonConfig.ToDataTable(db.Database.SqlQuery <POPrintReportViewModal>(sql, parameters).ToList());
}
catch (Exception ex)
{
//SaveErrorLog("JobRepository", "GetJobListByPaging", ex);
}
}
if (dtPO != null)
{
rvReport.Reset();
rvReport.LocalReport.DataSources.Clear();
rvReport.ProcessingMode = ProcessingMode.Local;
rvReport.LocalReport.EnableExternalImages = true;
rvReport.LocalReport.ReportPath = Server.MapPath("~/Report/RPT_INV_PurchaseOrder_Print.rdlc");
rvReport.LocalReport.DataSources.Add(new ReportDataSource("PP_INV_PurchaseOrder_SelectForPrint", dtPO));
rvReport.Visible = true;
rvReport.LocalReport.DisplayName = "Purchase Order";
rvReport.LocalReport.Refresh();
rvReport.DataBind();
}
else
{
rvReport.Visible = false;
}
}
else
{
rvReport.Visible = false;
}
}
// GET: PartialViewMenu
public ActionResult _MainMenu()
{
DB_A157D8_AnjaliMISEntities1 usersEntities = new DB_A157D8_AnjaliMISEntities1();
List <MenuViewModal> _MenuViewModal = new List <MenuViewModal>();
// var data = usersEntities.PR_SEC_UserPrivileges_SelectByUserID(Convert.ToInt32(Session["UserID"].ToString())).ToList();
using (DB_A157D8_AnjaliMISEntities1 db = new DB_A157D8_AnjaliMISEntities1())
{
try
{
//var outParam = new SqlParameter("@UserID", SqlDbType.Int);
//outParam.Direction = ParameterDirection.Output;
var sql = "exec PR_SEC_UserPrivileges_SelectByUserID @UserID";
List <SqlParameter> parameterList = new List <SqlParameter>();
parameterList.Add(new SqlParameter("@UserID", Convert.ToInt32(Session["UserID"].ToString())));
//parameterList.Add(outParam);
SqlParameter[] parameters = parameterList.ToArray();
var data1 = db.Database.SqlQuery <MenuViewModal>(sql, parameters).ToList();
_MenuViewModal = data1.Select(dataElement => new MenuViewModal()
{
ModuleID = dataElement.ModuleID,
ModuleName = dataElement.ModuleName,
Controller = dataElement.Controller,
Action = dataElement.Action,
URL = dataElement.URL,
IconName = dataElement.IconName,
StrictlyStop = dataElement.StrictlyStop,
Sequence = dataElement.Sequence,
UserID = dataElement.UserID
}).ToList();
}
catch (Exception ex)
{
//SaveErrorLog("JobRepository", "GetJobListByPaging", ex);
}
}
return(PartialView("_MainMenu", _MenuViewModal));
//return PartialView(_MenuViewModal);
}
public ActionResult Login(LoginViewModal objUser)
{
if (ModelState.IsValid)
{
using (DB_A157D8_AnjaliMISEntities1 db = new DB_A157D8_AnjaliMISEntities1())
{
var obj = db.SEC_User.Where(a => a.UserName.Equals(objUser.UserName) && a.Password.Equals(objUser.Password) && a.IsActive == true).FirstOrDefault();
if (obj != null)
{
Session["UserID"] = obj.UserID.ToString();
Session["UserName"] = obj.UserName.ToString();
#region SEC_LoginHistory
SEC_LoginHistory sEC_LoginHistory = new SEC_LoginHistory();
sEC_LoginHistory.Created = DateTime.Now;
sEC_LoginHistory.Modified = DateTime.Now;
sEC_LoginHistory.LoginTime = DateTime.Now;
sEC_LoginHistory.LogoutTime = DateTime.Now;
sEC_LoginHistory.Remarls = "Login..";
if (Session["UserID"] != null)
{
sEC_LoginHistory.UserID = Convert.ToInt16(Session["UserID"].ToString());
}
if (ModelState.IsValid)
{
db.SEC_LoginHistory.Add(sEC_LoginHistory);
db.SaveChanges();
if (sEC_LoginHistory.LoginHistoryID > 0)
{
Session["LoginHistoryID"] = sEC_LoginHistory.LoginHistoryID.ToString();
}
}
#endregion SEC_LoginHistory
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Enter valid Credentials..");
}
}
}
return(View(objUser));
}
// GET: PartialViewMenu
public ActionResult _MainMenu()
{
DB_A157D8_AnjaliMISEntities1 usersEntities = new DB_A157D8_AnjaliMISEntities1();
List <MenuViewModal> _MenuViewModal = new List <MenuViewModal>();
var data = usersEntities.PR_SEC_UserPrivileges_SelectByUserID(Convert.ToInt32(Session["UserID"].ToString())).ToList();
_MenuViewModal = data.Select(dataElement => new MenuViewModal()
{
ModuleID = dataElement.ModuleID,
ModuleName = dataElement.ModuleName,
Controller = dataElement.Controller,
Action = dataElement.Action,
URL = dataElement.URL,
IconName = dataElement.IconName,
StrictlyStop = dataElement.StrictlyStop,
Sequence = dataElement.Sequence,
UserID = dataElement.UserID
}).ToList();
return(PartialView("_MainMenu", _MenuViewModal));
//return PartialView(_MenuViewModal);
}
protected void btnShow_Click(object sender, EventArgs e)
{
SqlInt32 CategoryID = SqlInt32.Null;
String CategoryName = String.Empty;
DataTable dtItem = new DataTable();
List <ItemStockReportViewModal> _ItemStockReportViewModal = new List <ItemStockReportViewModal>();
if (ddlCategoryID.SelectedIndex > 0)
{
CategoryID = Convert.ToInt32(ddlCategoryID.SelectedValue);
CategoryName = ddlCategoryID.SelectedItem.Text;
}
using (DB_A157D8_AnjaliMISEntities1 db = new DB_A157D8_AnjaliMISEntities1())
{
try
{
var sql = "exec PP_INV_Item_SelectItemStockReportByCategoryID @CategoryID,@CompanyID";
List <SqlParameter> parameterList = new List <SqlParameter>();
parameterList.Add(new SqlParameter("@CategoryID", CategoryID));
parameterList.Add(new SqlParameter("@CompanyID", CommonConfig.GetCompanyID()));
SqlParameter[] parameters = parameterList.ToArray();
dtItem = CommonConfig.ToDataTable(db.Database.SqlQuery <ItemStockReportViewModal>(sql, parameters).ToList());
//_ItemStockReportViewModal = data1.Select(dataElement => new ItemStockReportViewModal()
//{
// ModuleID = dataElement.ModuleID,
// ModuleName = dataElement.ModuleName,
// Controller = dataElement.Controller,
// Action = dataElement.Action,
// URL = dataElement.URL,
// IconName = dataElement.IconName,
// StrictlyStop = dataElement.StrictlyStop,
// Sequence = dataElement.Sequence,
// UserID = dataElement.UserID
//}).ToList();
}
catch (Exception ex)
{
//SaveErrorLog("JobRepository", "GetJobListByPaging", ex);
}
}
//using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_A157D8_AnjaliMISEntities1"].ConnectionString))
//{
// using (SqlCommand cmd = new SqlCommand("PP_INV_Item_SelectItemStockReportByCategoryID", con))
// {
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.Add("@CategoryID", SqlDbType.Int).Value = CategoryID;
// cmd.Parameters.Add("@CompanyID", SqlDbType.Int).Value = CommonConfig.GetCompanyID();
// con.Open();
// SqlDataReader dr = cmd.ExecuteReader();
// dtItem.Load(dr);
// }
//}
if (dtItem != null)
{
rvReport.Reset();
rvReport.LocalReport.DataSources.Clear();
rvReport.ProcessingMode = ProcessingMode.Local;
rvReport.LocalReport.EnableExternalImages = true;
rvReport.LocalReport.ReportPath = Server.MapPath("~/Report/RPT_INV_Item_Stock.rdlc");
rvReport.LocalReport.DataSources.Add(new ReportDataSource("PP_INV_Item_SelectItemStockReportByCategoryID", dtItem));
rvReport.Visible = true;
rvReport.LocalReport.DisplayName = "Item Stock Report";
rvReport.LocalReport.Refresh();
rvReport.DataBind();
}
else
{
rvReport.Visible = false;
}
}
public static string GetNextNumber(string _NumberFor)
{
var db = new DB_A157D8_AnjaliMISEntities1();
Int32 _NewIssueNo = 0;
String _NewIssueReturnNo = "";
if (_NumberFor == "Issue")
{
Int32 TotalForMonth = db.INV_IssueReturn.Where(p => p.Created.Month == DateTime.Today.Month && p.Created.Year == DateTime.Today.Year && p.IssueReturnNo.Contains("IS")).Count();
Int32 NextCount = TotalForMonth + 1;
_NewIssueNo = Convert.ToInt32(DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + NextCount);
_NewIssueReturnNo = "IS-" + _NewIssueNo;
#region Check No
INV_IssueReturn _INV_IssueReturnNo = db.INV_IssueReturn.Where(w => w.IssueReturnNo == _NewIssueReturnNo).FirstOrDefault();
if (_INV_IssueReturnNo != null)
{
NextCount = NextCount + 1;
_NewIssueNo = Convert.ToInt32(DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + NextCount);
_NewIssueReturnNo = "IS-" + _NewIssueNo;
}
#endregion Check No
}
if (_NumberFor == "Return")
{
Int32 TotalForMonth = db.INV_IssueReturn.Where(p => p.Created.Month == DateTime.Today.Month && p.Created.Year == DateTime.Today.Year && p.IssueReturnNo.Contains("RN")).Count();
Int32 NextCount = TotalForMonth + 1;
_NewIssueNo = Convert.ToInt32(DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + NextCount);
_NewIssueReturnNo = "RN-" + _NewIssueNo;
#region Check No
INV_IssueReturn _INV_IssueReturnNo = db.INV_IssueReturn.Where(w => w.IssueReturnNo == _NewIssueReturnNo).FirstOrDefault();
if (_INV_IssueReturnNo != null)
{
NextCount = NextCount + 1;
_NewIssueNo = Convert.ToInt32(DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + NextCount);
_NewIssueReturnNo = "RN-" + _NewIssueNo;
}
#endregion Check No
}
if (_NumberFor == "Invoice")
{
Int32 TotalForMonth = db.INV_Invoice.Where(p => p.Created.Month == DateTime.Today.Month && p.Created.Year == DateTime.Today.Year).Count();
Int32 NextCount = TotalForMonth + 1;
_NewIssueNo = Convert.ToInt32(DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + NextCount);
_NewIssueReturnNo = "INV-" + _NewIssueNo;
#region Check No
INV_Invoice _INV_IssueReturnNo = db.INV_Invoice.Where(w => w.InvoiceNo == _NewIssueReturnNo).FirstOrDefault();
if (_INV_IssueReturnNo != null)
{
NextCount = NextCount + 1;
_NewIssueNo = Convert.ToInt32(DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + NextCount);
_NewIssueReturnNo = "INV-" + _NewIssueNo;
}
#endregion Check No
}
if (_NumberFor == "PO")
{
Int32 TotalForMonth = db.INV_PurchaseOrder.Where(p => p.Created.Month == DateTime.Today.Month && p.Created.Year == DateTime.Today.Year).Count();
Int32 NextCount = TotalForMonth + 1;
_NewIssueNo = Convert.ToInt32(DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + NextCount);
_NewIssueReturnNo = "PO-" + _NewIssueNo;
#region Check No
INV_PurchaseOrder _INV_IssueReturnNo = db.INV_PurchaseOrder.Where(w => w.PONo == _NewIssueReturnNo).FirstOrDefault();
if (_INV_IssueReturnNo != null)
{
NextCount = NextCount + 1;
_NewIssueNo = Convert.ToInt32(DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + NextCount);
_NewIssueReturnNo = "PO-" + _NewIssueNo;
}
#endregion Check No
}
return(_NewIssueReturnNo);
}
