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"));
}
