public ActionResult AddGR(ChallanModel model, string cmd)
{
ChallanService objService = new ChallanService();
int id = Convert.ToInt32(Url.RequestContext.RouteData.Values["id"].ToString());
model.CID = id;
if (cmd == "Add")
{
objService.InsertChallanTran(model);
}
else
{
objService.Update(model);
}
int uid = 0;
int cid = 0;
int rid = 0;
if (Session["UserId"] != null)
{
uid = Convert.ToInt32(Session["UserId"].ToString());
cid = Convert.ToInt32(Session["CompID"].ToString());
rid = Convert.ToInt32(Session["CompID"].ToString());
}
ChallanModel objModel = new ChallanModel();
List <ChallanModel> lstChallan = new List <ChallanModel>();
objModel = objService.GetById(id);
List <ConsignmentModel> lstGrNo = new List <ConsignmentModel>();
lstGrNo = objService.getGRNo(rid, cid);
objModel.ListGrNo = new List <ConsignmentModel>();
objModel.ListGrNo.AddRange(lstGrNo);
List <VehicleItem> lstVehicle = new List <VehicleItem>();
lstVehicle = objService.getVehicle(rid, cid);
objModel.ListVehicle = new List <VehicleItem>();
objModel.ListVehicle.AddRange(lstVehicle);
List <EmployeeItem> lstEmp = new List <EmployeeItem>();
lstEmp = objService.GetEmp(cid);
objModel.ListEmp = new List <EmployeeItem>();
objModel.ListEmp.AddRange(lstEmp);
lstChallan = objService.getChallanTran(id);
objModel.ListChallan = new List <ChallanModel>();
objModel.ListChallan.AddRange(lstChallan);
ViewBag.Menuid = Request.QueryString["menuId"];
return(View(objModel));
}
public ActionResult PrintChallan(string id)
{
ChallanService objService = new ChallanService();
ChallanModel objModel = new ChallanModel();
List <ChallanModel> lstChallan = new List <ChallanModel>();
EncDec objEnDec = new EncDec();
string cid = objEnDec.Decrypt(id);
objModel = objService.GetById(Convert.ToInt32(cid));
lstChallan = objService.getChallanTran(Convert.ToInt32(cid));
objModel.ListChallanTran = new List <ChallanModel>();
objModel.ListChallanTran.AddRange(lstChallan);
return(View(objModel));
}
public ActionResult Index()
{
ChallanService objService = new ChallanService();
ChallanModel objModel = new ChallanModel();
List <ChallanModel> lstChallan = new List <ChallanModel>();
int uid = 0;
int cid = 0;
int rid = 0;
if (Session["UserId"] != null)
{
uid = Convert.ToInt32(Session["UserId"].ToString());
cid = Convert.ToInt32(Session["CompID"].ToString());
rid = Convert.ToInt32(Session["CompID"].ToString());
}
List <VehicleItem> lstVehicle = new List <VehicleItem>();
lstVehicle = objService.getVehicle(rid, cid);
objModel.ListVehicle = new List <VehicleItem>();
objModel.ListVehicle.AddRange(lstVehicle);
List <EmployeeItem> lstEmp = new List <EmployeeItem>();
lstEmp = objService.GetEmp(cid);
objModel.ListEmp = new List <EmployeeItem>();
objModel.ListEmp.AddRange(lstEmp);
List <ConsignmentModel> lstGrNo = new List <ConsignmentModel>();
lstGrNo = objService.getGRNo(rid, cid);
objModel.ListGrNo = new List <ConsignmentModel>();
objModel.ListGrNo.AddRange(lstGrNo);
lstChallan = objService.getAllChallan(rid, cid);
objModel.ListChallan = new List <ChallanModel>();
objModel.ListChallan.AddRange(lstChallan);
lstChallan = objService.getAllChallanTran();
objModel.ListChallanTran = new List <ChallanModel>();
objModel.ListChallanTran.AddRange(lstChallan);
ViewBag.Menuid = Request.QueryString["menuId"];
return(View(objModel));
}
public ActionResult Index(ChallanModel model)
{
ChallanService objService = new ChallanService();
int uid = 0;
int cid = 0;
int rid = 0;
if (Session["UserId"] != null)
{
uid = Convert.ToInt32(Session["UserId"].ToString());
cid = Convert.ToInt32(Session["CompID"].ToString());
rid = Convert.ToInt32(Session["CompID"].ToString());
}
model.CompID = cid;
model.ChallanNo = "CHLN";
model.Status = true;
objService.Insert(model);
return(RedirectToAction("Index", new { @menuId = model.Viewbagidformenu }));
}
public ActionResult getGRDetail(int GRID)
{
int uid = 0;
int cid = 0;
int rid = 0;
if (Session["UserId"] != null)
{
uid = Convert.ToInt32(Session["UserId"].ToString());
cid = Convert.ToInt32(Session["CompID"].ToString());
rid = Convert.ToInt32(Session["CompID"].ToString());
}
ConsignmentModel objModel = new ConsignmentModel();
ChallanService objService = new ChallanService();
objModel = objService.getGR(GRID);
//return Json(objModel, JsonRequestBehavior.AllowGet);
return(PartialView("_GRDetail", objModel));
}
public ActionResult FillEmp()
{
int uid = 0;
int cid = 0;
int rid = 0;
if (Session["UserId"] != null)
{
uid = Convert.ToInt32(Session["UserId"].ToString());
cid = Convert.ToInt32(Session["CompID"].ToString());
rid = Convert.ToInt32(Session["CompID"].ToString());
}
List <VehicleItem> lstVhcl = new List <VehicleItem>();
VehicleItem objVhclModel = new VehicleItem();
ChallanService objEmp = new ChallanService();
lstVhcl = objEmp.getVehicle(rid, cid);
objVhclModel.ListVehicle = new List <VehicleItem>();
objVhclModel.ListVehicle.AddRange(lstVhcl);
return(Json(objVhclModel.ListVehicle, JsonRequestBehavior.AllowGet));
}
public ActionResult Create(Challan challan, FormCollection fc)
{
string ErrorMessage = "";
int count = 0;
try
{
if (challan.StudentID == null)
{
challan.StudentID = 0;
}
challan.IsDeposited = "No";
if (challan.BatchProgramID == 0 || challan.BatchProgramID == null)
{
count++;
ErrorMessage += count + "-" + string.Concat("Please select Program.") + "<br />";
ViewBag.MessageType = "error";
}
if (challan.YearSemesterNo == 0 || challan.YearSemesterNo == null)
{
count++;
ErrorMessage += count + "-" + string.Concat("Please select Year/Semester.") + "<br />";
ViewBag.MessageType = "error";
}
if (challan.IssueDate == null)
{
count++;
ErrorMessage += count + "-" + string.Concat("Please enter valid Issue Date.") + "<br />";
ViewBag.MessageType = "error";
}
if (challan.LastDate == null)
{
count++;
ErrorMessage += count + "-" + string.Concat("Please enter valid Last Date.") + "<br />";
ViewBag.MessageType = "error";
}
if (challan.AccountID == null || challan.AccountID == 0)
{
count++;
ErrorMessage += count + "-" + string.Concat("Please select Bank Account.") + "<br />";
ViewBag.MessageType = "error";
}
if (string.IsNullOrEmpty(ErrorMessage))
{
List <StudentProgramEnrollment> lstSPE = db.StudentProgramEnrollments.Where(s => s.BatchProgramID == challan.BatchProgramID).ToList();
foreach (var item in lstSPE)
{
Challan ch = new Challan();
ch.FormNo = db.Students.FirstOrDefault(s => s.StudentID == item.StudentID).FormNo;
ch.StudentID = item.StudentID;
ch.BatchProgramID = item.BatchProgramID;
ch.IssueDate = challan.IssueDate;
ch.LastDate = challan.LastDate;
ch.AccountID = challan.AccountID;
ch.IsDeposited = "No";
ch.YearSemesterNo = challan.YearSemesterNo;
ch.Voucher_Trans_ID = 0;
ch.CreatedBy = Convert.ToInt32(Session["emp_id"]);
ch.IsActive = "Yes";
db.Challans.Add(ch);
db.SaveChanges();
//Getting Scope Identity
challan.ChallanID = ch.ChallanID;
//Inserting ChallanServices
int totalRows = Convert.ToInt32(fc["TotalRows"]);
for (int i = 1; i <= totalRows; i++)
{
if (fc["Amount_" + i] != null && fc["Amount_" + i] != "" && fc["Amount_" + i] != "0")
{
try
{
int?Quantity = Convert.ToInt32(fc["Quantity_" + i]);
if (Quantity == 0 || Quantity == null)
{
challan.Quantity = 1;
}
else
{
challan.Quantity = Quantity;
}
int CollegeServiceID = Convert.ToInt32(fc["CollegeServiceID_" + i]);
ChallanService chs = new ChallanService();
chs.ChallanID = challan.ChallanID;
chs.CollegeServiceID = CollegeServiceID;
chs.Amount = Convert.ToInt32(fc["Amount_" + i]);
chs.Quantity = challan.Quantity;
db.ChallanServices.Add(chs);
db.SaveChanges();
}
catch (EntityCommandExecutionException)
{
ViewBag.MessageType = "success";
ViewBag.Message = "Data has been saved successfully.";
}
}
}
}
ViewBag.MessageType = "success";
ViewBag.Message = "Data has been saved successfully.";
}
else
{
ViewBag.Message = ErrorMessage;
}
}
catch (Exception ex)
{
ViewBag.MessageType = "error";
ViewBag.Message = ex.Message;
}
model.Challans = db.GetAllChallans(challan.BatchProgramID, challan.StudentID, challan.YearSemesterNo).ToList();
model.SelectedChallan = null;
model.DisplayMode = "WriteOnly";
ViewBag.IsActive = new SelectList(db.Options, "OptionDesc", "OptionDesc", challan.IsActive);
ViewBag.BatchProgramID = new SelectList(db.GetBatchProgramNameConcat("", 0), "ID", "Name", challan.BatchProgramID);
ViewBag.YearSemesterNo = new SelectList(db.Semesters, "YearSemesterNo", "YearSemesterNo", challan.YearSemesterNo);
ViewBag.AccountID = new SelectList(dbFinance.Bank_Account, "Account_ID", "Account_No", challan.AccountID);
return(View("Index", model));
}
public ActionResult InsertStudentChallan(int?StudentID, FormCollection fc)
{
GetEnrolledStudent_Result objES = db.GetEnrolledStudent(StudentID.ToString()).FirstOrDefault();
string ErrorMessage = "";
int count = 0;
int? QuantityMain = 0;
if (objES != null)
{
try
{
objES.IssueDate = fc["IssueDate"];
objES.LastDate = fc["LastDate"];
objES.YearSemesterNo = Convert.ToInt32(fc["YearSemesterNo"]);
objES.AccountID = fc["AccountID"];
if (objES.YearSemesterNo == 0)
{
count++;
ErrorMessage += count + "-" + string.Concat("Please select Year/Semester.") + "<br />";
ViewBag.MessageType = "error";
}
if (string.IsNullOrEmpty(objES.IssueDate))
{
count++;
ErrorMessage += count + "-" + string.Concat("Please enter valid Issue Date.") + "<br />";
ViewBag.MessageType = "error";
}
if (string.IsNullOrEmpty(objES.LastDate))
{
count++;
ErrorMessage += count + "-" + string.Concat("Please enter valid Last Date.") + "<br />";
ViewBag.MessageType = "error";
}
if (string.IsNullOrEmpty(objES.AccountID))
{
count++;
ErrorMessage += count + "-" + string.Concat("Please select Bank Account.") + "<br />";
ViewBag.MessageType = "error";
}
if (string.IsNullOrEmpty(ErrorMessage))
{
Challan ch = new Challan();
ch.FormNo = objES.FormNo;
ch.StudentID = objES.StudentID;
ch.BatchProgramID = objES.BatchProgramID;
ch.IssueDate = Convert.ToDateTime(objES.IssueDate);
ch.LastDate = Convert.ToDateTime(objES.LastDate);
ch.AccountID = Convert.ToInt32(objES.AccountID);
ch.IsDeposited = "No";
ch.YearSemesterNo = objES.YearSemesterNo;
ch.Voucher_Trans_ID = 0;
ch.CreatedBy = Convert.ToInt32(Session["emp_id"]);
ch.IsActive = "Yes";
db.Challans.Add(ch);
db.SaveChanges();
//Getting Scope Identity
int ChallanID = ch.ChallanID;
//Inserting ChallanServices
int totalRows = Convert.ToInt32(fc["TotalRows"]);
for (int i = 1; i <= totalRows; i++)
{
if (fc["Amount_" + i] != null && fc["Amount_" + i] != "" && fc["Amount_" + i] != "0")
{
try
{
int?Quantity = Convert.ToInt32(fc["Quantity_" + i]);
if (Quantity == 0 || Quantity == null)
{
QuantityMain = 1;
}
else
{
QuantityMain = Quantity;
}
int CollegeServiceID = Convert.ToInt32(fc["CollegeServiceID_" + i]);
ChallanService chs = new ChallanService();
chs.ChallanID = ChallanID;
chs.CollegeServiceID = CollegeServiceID;
chs.Amount = Convert.ToInt32(fc["Amount_" + i]);
chs.Quantity = QuantityMain;
db.ChallanServices.Add(chs);
db.SaveChanges();
}
catch (EntityCommandExecutionException)
{
}
}
}
ViewBag.MessageType = "success";
ViewBag.Message = "Data has been saved successfully.";
}
else
{
ViewBag.Message = ErrorMessage;
}
}
catch (Exception ex)
{
ViewBag.MessageType = "error";
ViewBag.Message = ex.Message;
}
}
else
{
ViewBag.MessageType = "error";
ViewBag.Message = "No student found to add challan.";
}
ViewBag.objES = objES;
ViewBag.AccountID = new SelectList(dbFinance.Bank_Account, "Account_ID", "Account_No");
ViewBag.YearSemesterNo = new SelectList(db.Semesters, "YearSemesterNo", "YearSemesterNo");
ViewBag.StudentID = StudentID;
return(View("SingleStudentChallan"));
}