public ActionResult UpdateTypesofEstirack(EshtiracksType Eshtirackstype)
{
try
{
using (ArchitectureEntitiesModel entities = new ArchitectureEntitiesModel())
{
EshtiracksType updatedTypesofEstiracks = (from c in entities.EshtiracksTypes
where c.Id == Eshtirackstype.Id
select c).FirstOrDefault();
updatedTypesofEstiracks.Description = Eshtirackstype.Description;
updatedTypesofEstiracks.Amount = Eshtirackstype.Amount;
entities.SaveChanges();
int id = Eshtirackstype.Id;
if (id > 0)
{
TempData["Success"] = "Successfully Updated";
TempData["Heading"] = 1;
return(RedirectToAction("TypesofEstiracks"));
}
else
{
TempData["Failed"] = "Not Updated";
return(View());
}
}
}
catch (Exception ex)
{
TempData["Failed"] = "Exception Occured";
return(View());
}
}
public ActionResult UpdateClientsGridView(ClientsView clientsview)
{
try
{
using (ArchitectureEntitiesModel entities = new ArchitectureEntitiesModel())
{
ClientsView updatedclientsview = (from c in entities.ClientsViews
where c.Id == clientsview.Id
select c).FirstOrDefault();
updatedclientsview.Name = clientsview.Name;
updatedclientsview.Location = clientsview.Location;
updatedclientsview.Type = clientsview.Type;
updatedclientsview.Date = clientsview.Date;
updatedclientsview.Amount = clientsview.Amount;
updatedclientsview.FullPaymentuptodate = clientsview.FullPaymentuptodate;
updatedclientsview.EntryDate = DateTime.Now;
entities.SaveChanges();
TempData["Success"] = "Successfully Updated";
}
}
catch (Exception ex) { }
return(RedirectToAction("ClientsGridView"));
}
public ActionResult TypesofEstiracks(EshtiracksType Eshtirackstype)
{
try {
if (ModelState.IsValid)
{
using (ArchitectureEntitiesModel entities = new ArchitectureEntitiesModel())
{
entities.EshtiracksTypes.Add(Eshtirackstype);
entities.SaveChanges();
int id = Eshtirackstype.Id;
if (id > 0)
{
TempData["Success"] = "Successfully Saved";
}
else
{
TempData["Failed"] = "Not Saved";
}
}
}
}
catch (Exception ex)
{
TempData["Failed"] = "Exception Occured";
return(View());
}
return(RedirectToAction("TypesofEstiracks"));
}
//[ValidateAntiForgeryToken]
public ActionResult Login(UserProfile objUser)
{
try
{
if (ModelState.IsValid)
{
using (ArchitectureEntitiesModel db = new ArchitectureEntitiesModel())
{
var obj = db.UserProfiles.Where(a => a.Email.Equals(objUser.Email) && a.Password.Equals(objUser.Password)).FirstOrDefault();
if (obj != null)
{
Session["UserID"] = obj.UserId.ToString();
Session["Image"] = obj.Image.ToString();
Session["UserName"] = obj.UserName.ToString();
return(RedirectToAction("UserDashBoard"));
}
else
{
TempData["Failed"] = "Invalid Username or Password";
return(RedirectToAction("Login", "Account"));
}
}
}
TempData["Failed"] = "Invalid Username or Password";
}
catch (Exception ex) { }
return(RedirectToAction("Login", "Account"));
}
public ActionResult ExpensesListNames()
{
try {
using (ArchitectureEntitiesModel ObjEntities = new ArchitectureEntitiesModel())
{
var getexpenselist = ObjEntities.ExpenseListNames.OrderByDescending(e => e.Id).ToList();
if (getexpenselist.Count != 0)
{
List <ExpenseListVM> Expenselist = new List <ExpenseListVM>();
foreach (var i in getexpenselist)
{
ExpenseListVM v = new ExpenseListVM();
v.Id = i.Id;
v.Description = i.Description;
v.IconPath = i.IconPath;
Expenselist.Add(v);
}
TempData["Expenselist"] = Expenselist;
}
}
}
catch (Exception ex)
{
}
TempData["Heading"] = 2;
return(View());
}
public ActionResult Recapperexpensetype()
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
try
{
using (ArchitectureEntitiesModel ObjEntities = new ArchitectureEntitiesModel())
{
var ClientExpense = new SelectList(ObjEntities.ExpenseListNames.ToList(), "Id", "Description");
ViewData["ClientExpense"] = ClientExpense;
}
string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
string query = "Select * from ClientsExpense as C inner join ExpenseListNames as E on E.Id=C.Expensetype";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(dt);
}
ds.Tables.Add(dt);
}
}
TempData["Heading"] = 7;
}
catch (Exception ex) { }
return(View(ds));
}
public ActionResult AddExpense(ClientsExpense clientexpense)
{
try {
if (ModelState.IsValid)
{
using (ArchitectureEntitiesModel ObjEntities = new ArchitectureEntitiesModel())
{
clientexpense.EntryDate = DateTime.Now;
ObjEntities.ClientsExpenses.Add(clientexpense);
ObjEntities.SaveChanges();
int id = clientexpense.Id;
if (id > 0)
{
TempData["Success"] = "Successfully Saved";
}
else
{
TempData["Failed"] = "Not Saved";
}
}
}
}
catch (Exception ex) { }
//var Clients = new SelectList(ObjEntities.ClientsView.ToList(), "Id", "Name");
//ViewData["ClientPayment"] = Clients;
return(RedirectToAction("ChooseExpense"));;
}
public ActionResult ClientsGridView(ClientsView clientsview, FormCollection Form)
{
try {
if (ModelState.IsValid)
{
using (ArchitectureEntitiesModel ObjEntities = new ArchitectureEntitiesModel())
{
clientsview.Date = DateTime.Parse(clientsview.Date.ToShortTimeString());
clientsview.FullPaymentuptodate = DateTime.Parse(clientsview.FullPaymentuptodate.ToShortTimeString());
clientsview.EntryDate = DateTime.Parse(DateTime.Now.ToShortTimeString());
ObjEntities.ClientsViews.Add(clientsview);
ObjEntities.SaveChanges();
int id = clientsview.Id;
if (id > 0)
{
TempData["Success"] = "Successfully Saved";
}
else
{
TempData["Failed"] = "Not Saved";
}
}
}
}
catch (Exception ex) { }
//TempData["ClientData"] = ObjEntities.ClientsView.ToList();
return(RedirectToAction("ClientsGridView"));
}
public ActionResult UpdateClientsPayment(ClientsPayment clientspayment)
{
try {
using (ArchitectureEntitiesModel entities = new ArchitectureEntitiesModel())
{
var getclientpayment = ObjEntities.ClientsPayments.Where(e => e.Client == clientspayment.Client).FirstOrDefault();
var getclient = ObjEntities.ClientsViews.Where(e => e.Id == clientspayment.Client).FirstOrDefault();
if (getclientpayment != null)
{
if (Convert.ToInt32(clientspayment.Paid_Amount) <= Convert.ToInt32(getclient.Amount))
{
int Due = Convert.ToInt32(getclient.Amount) - Convert.ToInt32(clientspayment.Paid_Amount);
getclientpayment.Paid_Amount = clientspayment.Paid_Amount;
getclientpayment.Due_Amount = Due.ToString();
//getclientpayment.EntryDate = Convert.ToDateTime(clientspayment.Month);
entities.SaveChanges();
TempData["Success"] = "Data Updated successfully";
}
else
{
TempData["Warning"] = "Paid Amount Should be less than due amount!";
return(RedirectToAction("EditClientsPayment"));
}
}
//if (long.Parse(clientspayment.Paid_Amount.ToString()) <= long.Parse(getclientpayment.Due_Amount.ToString()))
//{
// ClientsPayment updatedclientspayment = (from c in entities.ClientsPayments
// where c.Id == clientspayment.Id
// select c).FirstOrDefault();
// updatedclientspayment.Client = clientspayment.Client;
// updatedclientspayment.Month = clientspayment.Month;
// updatedclientspayment.Paid_Amount = Convert.ToString(long.Parse((updatedclientspayment.Paid_Amount)) + long.Parse((clientspayment.Paid_Amount)));
// updatedclientspayment.Due_Amount = Convert.ToString(long.Parse((getclient.Amount)) - long.Parse((updatedclientspayment.Paid_Amount)));
// updatedclientspayment.Month = clientspayment.Month;
// updatedclientspayment.EntryDate = DateTime.Now;
// entities.SaveChanges();
// TempData["Success"] = "Successfully updated";
//}
//else
//{
// TempData["Warning"] = "Paid Amount Should be less than due amount!";
// return RedirectToAction("EditClientsPayment");
//}
}
}
catch (Exception ex) { }
return(RedirectToAction("AddPayments"));
}
public ActionResult Recappermonth(FormCollection Form)
{
DataSet ds = new DataSet();
DataTable dt = new DataTable();
try
{
string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (ArchitectureEntitiesModel ObjEntities = new ArchitectureEntitiesModel())
{
var GetMonth = new SelectList(ObjEntities.tblMonths.ToList(), "Id", "Month");
ViewData["GetMonth"] = GetMonth;
}
using (SqlConnection con = new SqlConnection(constr))
{
string selectmonth = Request.Form["Month"].ToString();
string query = "Select FORMAT(E.MonthDate,'MMMM') as Month, Sum(cast(C.[Paid Amount] as float(10))) as Income,isnull(E.Amount, 0) as Expense from ClientsPayment as C inner join ClientsExpense as E on Month(E.MonthDate)= Month(C.Month) where Month(E.MonthDate)=" + selectmonth + " group by C.Month, E.MonthDate,E.Amount order by C.Month";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(dt);
}
DataColumn newCol = new DataColumn("NetAmount", typeof(Int64));
dt.Columns.Add(newCol);
foreach (DataRow row in dt.Rows)
{
Int64 Income = Int64.Parse(row.ItemArray[1].ToString());
Int64 expense = Int64.Parse(row.ItemArray[2].ToString());
row["NetAmount"] = Income - expense;
}
ds.Tables.Add(dt);
}
}
TempData["Heading"] = 6;
}
catch (Exception ex) { }
return(View(ds));
}
public ActionResult Recapperclient()
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
try {
string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (ArchitectureEntitiesModel ObjEntities = new ArchitectureEntitiesModel())
{
var ClientExpense = new SelectList(ObjEntities.ClientsViews.ToList(), "Id", "Name");
ViewData["recapperclient"] = ClientExpense;
}
if (TempData["Isfilter"] == null || TempData["Isfilter"].ToString() == "0")
{
string query = "Select * from ClientsPayment as P inner join ClientsView as C on C.Id=P.Client";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(dt);
}
ds.Tables.Add(dt);
}
}
else
{
TempData["Isfilter"] = 0;
return(View(dsfilter));
}
}
TempData["Heading"] = 8;
}
catch (Exception ex) { }
return(View(ds));
}
public ActionResult AddPayments()
{
TempData["Heading"] = 4;
try
{
using (ArchitectureEntitiesModel ObjEntities = new ArchitectureEntitiesModel())
{
var Client = new SelectList(ObjEntities.ClientsViews.ToList(), "Id", "Name");
var Month = new SelectList(ObjEntities.tblMonths.ToList(), "Id", "Month");
ViewData["ClientPayment"] = Client;
ViewData["Month"] = Month;
}
var getClientPayment = ObjEntities.ClientsPayments.OrderByDescending(p => p.Id).ToList();
if (getClientPayment.Count != 0)
{
List <ClientPaymentVM> ClientPaymentlist = new List <ClientPaymentVM>();
foreach (var i in getClientPayment)
{
ClientPaymentVM v = new ClientPaymentVM();
var getclient = ObjEntities.ClientsViews.Where(e => e.Id == i.Client).FirstOrDefault();
//var getmonth = ObjEntities.tblMonth.Where(e => e.Id == i.Month).FirstOrDefault();
if (getclient != null)
{
v.Client = getclient.Name;
}
else
{
v.Client = "No Result";
}
v.Id = i.Id;
v.Month = i.Month;
v.Due_Amount = i.Due_Amount;
v.Paid_Amount = i.Paid_Amount;
v.EntryDate = i.EntryDate;
ClientPaymentlist.Add(v);
}
TempData["ClientPaymentData"] = ClientPaymentlist;
}
}
catch (Exception ex) { }
return(View());
}
public ActionResult ChooseExpense()
{
TempData["Heading"] = 5;
try {
using (ArchitectureEntitiesModel ObjEntities = new ArchitectureEntitiesModel())
{
var ClientExpense = new SelectList(ObjEntities.ExpenseListNames.ToList(), "Id", "Description");
ViewData["ClientExpense"] = ClientExpense;
}
var getClientExpense = ObjEntities.ClientsExpenses.OrderByDescending(p => p.Id).ToList();
if (getClientExpense.Count != 0)
{
List <ClientExpenseVM> ClientExpenselist = new List <ClientExpenseVM>();
foreach (var i in getClientExpense)
{
ClientExpenseVM v = new ClientExpenseVM();
var getclientexpense = ObjEntities.ExpenseListNames.Where(e => e.Id == i.Expensetype).FirstOrDefault();
if (getclientexpense != null)
{
v.Expensetype = getclientexpense.Description;
}
else
{
v.Expensetype = "Select Expense Type";
}
v.Id = i.Id;
v.Amount = i.Amount;
v.MonthDate = i.MonthDate;
v.EntryDate = i.EntryDate;
ClientExpenselist.Add(v);
}
TempData["ClientExpenseData"] = ClientExpenselist;
}
}
catch (Exception ex) { }
return(View());
}
// GET: MainDashboard
public ActionResult ClientsGridView()
{
TempData["Heading"] = 3;
try {
using (ArchitectureEntitiesModel ObjEntities = new ArchitectureEntitiesModel())
{
var Eshtriackstype = new SelectList(ObjEntities.EshtiracksTypes.ToList(), "Id", "Description");
ViewData["EshtiracksTypes"] = Eshtriackstype;
}
var getClientData = ObjEntities.ClientsViews.OrderByDescending(c => c.Id).ToList();
if (getClientData.Count != 0)
{
List <ClientVM> ClientList = new List <ClientVM>();
foreach (var i in getClientData)
{
ClientVM v = new ClientVM();
v.Amount = i.Amount;
var getType = ObjEntities.EshtiracksTypes.Where(e => e.Id == i.Type).FirstOrDefault();
if (getType != null)
{
v.Type = getType.Description;
}
else
{
v.Type = "General";
}
v.Id = i.Id;
v.Name = i.Name;
v.Location = i.Location;
v.Date = i.Date;
v.FullPaymentuptodate = i.FullPaymentuptodate;
v.EntryDate = i.EntryDate;
ClientList.Add(v);
}
TempData["ClientData"] = ClientList;
}
}
catch (Exception ex) { }
return(View());
}
private void UpdateClientsPayment(string Amount, int id)
{
using (ArchitectureEntitiesModel entities = new ArchitectureEntitiesModel())
{
ClientsView updatedclientsview = (from c in entities.ClientsViews
where c.Id == id
select c).FirstOrDefault();
long clientamount = long.Parse(updatedclientsview.Amount);
long clientpayments = long.Parse(Amount);
long updatedamount = clientamount - clientpayments;
updatedclientsview.Amount = updatedamount.ToString();
updatedclientsview.EntryDate = DateTime.Now;
entities.SaveChanges();
}
}
public ActionResult UpdateClientsExpense(ClientsExpense clientsexpense)
{
try {
using (ArchitectureEntitiesModel entities = new ArchitectureEntitiesModel())
{
ClientsExpense updatedclientsexpenset = (from c in entities.ClientsExpenses
where c.Id == clientsexpense.Id
select c).FirstOrDefault();
updatedclientsexpenset.Expensetype = clientsexpense.Expensetype;
updatedclientsexpenset.Amount = clientsexpense.Amount;
updatedclientsexpenset.EntryDate = DateTime.Now;
entities.SaveChanges();
TempData["Success"] = "Successfully Updated";
}
}
catch (Exception ex) { }
return(RedirectToAction("ChooseExpense"));
}
public ActionResult UpdateExpensesListNames(ExpenseListName expenselistname, HttpPostedFileBase ImageFile)
{
try {
using (ArchitectureEntitiesModel entities = new ArchitectureEntitiesModel())
{
ExpenseListName updatedexpenselistname = (from c in entities.ExpenseListNames
where c.Id == expenselistname.Id
select c).FirstOrDefault();
updatedexpenselistname.Description = expenselistname.Description;
//expenselistname.ImageFile = new HttpPostedFile();
//Extract Image File Name.
if (ImageFile != null)
{
string fileName = System.IO.Path.GetFileName(ImageFile.FileName);
// Set the Image File Path.
string filePath = "~/Images/avatars/" + fileName;
//Save the Image File in Folder.
ImageFile.SaveAs(Server.MapPath(filePath));
updatedexpenselistname.IconPath = filePath;
}
entities.SaveChanges();
int id = expenselistname.Id;
if (id > 0)
{
TempData["Success"] = "Successfully Updated";
}
}
}
catch (Exception ex) { }
return(RedirectToAction("ExpensesListNames"));
}
public ActionResult Recapperclient(FormCollection form)
{
try
{
DataTable dt = new DataTable();
string constr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
string selectedclient = Request.Form["Client"].ToString();
using (ArchitectureEntitiesModel ObjEntities = new ArchitectureEntitiesModel())
{
var ClientExpense = new SelectList(ObjEntities.ClientsViews.ToList(), "Id", "Name");
ViewData["recapperclient"] = ClientExpense;
}
string query = "Select * from ClientsPayment as P inner join ClientsView as C on C.Id=P.Client where P.Client= " + selectedclient + "";
using (SqlCommand cmd = new SqlCommand(query))
{
cmd.Connection = con;
using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
{
sda.Fill(dt);
TempData["Isfilter"] = 1;
}
dsfilter.Tables.Add(dt);
}
}
TempData["Heading"] = 8;
}
catch { }
return(View(dsfilter));
}
public ActionResult AddPayments(ClientsPayment clientpayment)
{
try
{
if (ModelState.IsValid)
{
//UpdateClientsPayment(clientpayment.Paid_Amount,clientpayment.Client);
using (ArchitectureEntitiesModel ObjEntities = new ArchitectureEntitiesModel())
{
var getclient = ObjEntities.ClientsViews.Where(e => e.Id == clientpayment.Client).FirstOrDefault();
//My Code Saad Bhatti
var chkData = ObjEntities.ClientsPayments.Where(c => c.Client == clientpayment.Client &&
c.EntryDate.Year == clientpayment.Month.Year && c.EntryDate.Month == clientpayment.Month.Month).FirstOrDefault();
if (chkData != null)
{
if (Convert.ToInt32(getclient.Amount) >= Convert.ToInt32(clientpayment.Paid_Amount) + Convert.ToInt32(chkData.Paid_Amount))
{
if (long.Parse(clientpayment.Paid_Amount.ToString()) <= long.Parse(getclient.Amount.ToString()))
{
int TotalAmount = Convert.ToInt32(getclient.Amount);
int Due = Convert.ToInt32(TotalAmount) - (Convert.ToInt32(clientpayment.Paid_Amount) + (Convert.ToInt32(chkData.Paid_Amount)));
int Paid = Convert.ToInt32(chkData.Paid_Amount) + Convert.ToInt32(clientpayment.Paid_Amount);
chkData.Paid_Amount = Paid.ToString();
chkData.Due_Amount = Due.ToString();
ObjEntities.SaveChanges();
//clientpayment.EntryDate = DateTime.Now;
//chkData.Due_Amount = Due.ToString();
//ObjEntities.ClientsPayments.Add(clientpayment);
//ObjEntities.SaveChanges();
//int id1 = 0;
//id1 = clientpayment.Id;
//if (id1 > 0)
//{
// var getmonth = ObjEntities.tblMonth.Where(e => e.Id == clientpayment.Month).FirstOrDefault();
TempData["Success"] = Session["UserName"] + " " + "Added" + " " + clientpayment.Paid_Amount + " " + "for" + " " + getclient.Name + " " + "for" + " " + "Month" + "-" + clientpayment.Month.Month;
tblNotification tblnotification = new tblNotification();
tblnotification.NotificationMessage = Session["UserName"] + " " + "Added" + " " + clientpayment.Paid_Amount + " " + "for" + " " + getclient.Name + " " + "for" + " " + "Month" + "-" + clientpayment.Month.Month;
tblnotification.IsShow = 0;
ObjEntities.tblNotifications.Add(tblnotification);
ObjEntities.SaveChanges();
//}
}
else
{
TempData["Warning"] = "Paid Amount Should be less than due amount!";
}
}
else
{
TempData["Warning"] = "Paid Amount Should be less than due amount!";
}
}
else
{
int id = 0;
clientpayment.EntryDate = Convert.ToDateTime(clientpayment.Month);
clientpayment.Due_Amount = Convert.ToString(long.Parse((getclient.Amount)) - long.Parse((clientpayment.Paid_Amount)));
ObjEntities.ClientsPayments.Add(clientpayment);
ObjEntities.SaveChanges();
id = clientpayment.Id;
if (id > 0)
{
// var getmonth = ObjEntities.tblMonth.Where(e => e.Id == clientpayment.Month).FirstOrDefault();
TempData["Success"] = Session["UserName"] + " " + "Added" + " " + clientpayment.Paid_Amount + "Payment" + " " + "for" + " " + getclient.Name + " " + "for" + " " + "Month" + "-" + clientpayment.Month;
tblNotification tblnotification = new tblNotification();
tblnotification.NotificationMessage = Session["UserName"] + " " + "Added" + " " + clientpayment.Paid_Amount + " " + "for" + " " + getclient.Name + " " + "for" + " " + "Month" + "-" + clientpayment.Month;
tblnotification.IsShow = 0;
ObjEntities.tblNotifications.Add(tblnotification);
ObjEntities.SaveChanges();
}
}
}
}
//var Clients = new SelectList(ObjEntities.ClientsView.ToList(), "Id", "Name");
//ViewData["ClientPayment"] = Clients;
}
catch (Exception ex) { }
return(RedirectToAction("AddPayments"));
}
