public ActionResult SingleStudentChallan(int?StudentID) { GetEnrolledStudent_Result objES = db.GetEnrolledStudent(StudentID.ToString()).FirstOrDefault(); ViewBag.objES = objES; ViewBag.AccountID = new SelectList(dbFinance.Bank_Account, "Account_ID", "Account_No"); ViewBag.YearSemesterNo = new SelectList(db.Semesters, "YearSemesterNo", "YearSemesterNo"); ViewBag.MessageType = ""; ViewBag.Message = ""; ViewBag.StudentID = StudentID; return(View()); }
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")); }