public ActionResult Create([Bind(Include = "Studentid,StudentName,FatherName,Address,Contact,Laststudy,Medical,Refusal,Email,Password,RollNo")] StudentReg studentReg, Helper Help, string package, string advance) { if (ModelState.IsValid) { StudentReg studentreg1 = db.StudentRegs.FirstOrDefault(); if (studentreg1 == null) { studentReg.RollNo = 0001; } else { var ab = db.StudentRegs.Max(x => x.RollNo); studentReg.RollNo = Convert.ToInt32(ab) + 1; } studentReg.Fileno = "Jan/19"; db.StudentRegs.Add(studentReg); db.SaveChanges(); fees fee = new fees(); fee.studentid = studentReg.Fileno + "" + studentReg.RollNo; fee.Package = Convert.ToInt32(package); fee.Advance = Convert.ToInt32(advance); fee.pay = Convert.ToInt32(advance); fee.balance = fee.Package - fee.pay; db.fees.Add(fee); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(studentReg)); }
public ActionResult NewMoney(fees _fess, int?id, Logs _log) { if (Session["empName"] != null) { var _Case = _db.Cases.Where(s => s.id == id).FirstOrDefault(); if (_Case == null) { return(RedirectToAction("HavntAccess", "Employees")); } _fess.NumberOfCase = _Case.id; _fess.EmployeeName = Session["empName"].ToString(); _fess.DateofRevice = DateTime.Now; _db.feeses.Add(_fess); _log.username = Session["empName"].ToString(); _log.date = DateTime.Now; string ip = Request.UserHostAddress; _log.ipaddress = ip; _db.Logs.Add(_log); _db.SaveChanges(); return(RedirectToAction("MoneyDetalis/" + id)); } return(RedirectToAction("HavntAccess", "Employees")); }
public async Task <ActionResult> DeleteConfirmed(int id) { fees fees = await db.fees.FindAsync(id); db.fees.Remove(fees); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "feeid,studentid,Package,Advance,pay")] fees fees) { if (ModelState.IsValid) { db.Entry(fees).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(fees)); }
public async Task <ActionResult> Create([Bind(Include = "feeid,studentid,Package,Advance,pay")] fees fees) { if (ModelState.IsValid) { db.fees.Add(fees); await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(fees)); }
// GET: OfficialAdmin/fees/Delete/5 public async Task <ActionResult> Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } fees fees = await db.fees.FindAsync(id); if (fees == null) { return(HttpNotFound()); } return(View(fees)); }
public async Task <ActionResult> DeleteConfirmed(int id, fees fee) { SingleFee singleFee = await db.SingleFees.FindAsync(id); singleFee.studentid = regno; db.SingleFees.Remove(singleFee); await db.SaveChangesAsync(); fee = db.fees.Where(x => x.studentid == singleFee.studentid).FirstOrDefault(); fee.pay = fee.pay - lastfee; // fee.pay = fee.pay + singleFee.Paid; fee.balance = fee.Package - fee.pay; db.Entry(fee).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "StudentRegs")); //return RedirectToAction("Index"); }
public async Task <ActionResult> Create([Bind(Include = "sfid,studentid,Date,Paid,Billno,Receivedby")] SingleFee singleFee, fees fee) { if (ModelState.IsValid) { singleFee.studentid = regno; singleFee.Receivedby = Session["user"].ToString(); db.SingleFees.Add(singleFee); await db.SaveChangesAsync(); fee = db.fees.Where(x => x.studentid == singleFee.studentid).FirstOrDefault(); fee.pay = fee.pay + singleFee.Paid; fee.balance = fee.Package - fee.pay; db.Entry(fee).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index", "StudentRegs")); } // return View(singleFee); return(RedirectToAction("Index", "StudentRegs")); }
public JsonResult updateExcel(StudentReg studentreg, HttpPostedFileBase FileUpload) { List <string> data = new List <string>(); if (FileUpload != null) { // tdata.ExecuteCommand("truncate table OtherCompanyAssets"); if (FileUpload.ContentType == "application/vnd.ms-excel" || FileUpload.ContentType == "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet") { string filename = FileUpload.FileName; string targetpath = Server.MapPath("/DetailFormatInExcel/"); FileUpload.SaveAs(targetpath + filename); string pathToExcelFile = targetpath + filename; var connectionString = ""; if (filename.EndsWith(".xls")) { connectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0; data source={0}; Extended Properties=Excel 8.0;", pathToExcelFile); } else if (filename.EndsWith(".xlsx")) { connectionString = string.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=\"Excel 12.0 Xml;HDR=YES;IMEX=1\";", pathToExcelFile); } var adapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", connectionString); var ds = new DataSet(); adapter.Fill(ds, "ExcelTable"); DataTable dtable = ds.Tables["ExcelTable"]; string sheetName = "Sheet1"; var excelFile = new ExcelQueryFactory(pathToExcelFile); var artistAlbums = from a in excelFile.Worksheet <StudentReg>(sheetName) select a; foreach (DataRow a in dtable.Rows) { try { if (a["Student Name"] != "" && a["Address"] != "" && a["Contact"] != "") { StudentReg TU = new StudentReg(); StudentReg studentreg1 = db.StudentRegs.FirstOrDefault(); if (studentreg1 == null) { TU.RollNo = 0001; } else { var ab = db.StudentRegs.Max(x => x.RollNo); TU.RollNo = Convert.ToInt32(ab) + 1; } //TU.RollNo = Regno(rollno); //TU.RollNo = a.RollNo; TU.StudentName = a["Student Name"].ToString(); TU.FatherName = a["Father Name"].ToString(); TU.Address = a["Address"].ToString(); TU.Contact = a["Contact"].ToString(); TU.Laststudy = a["Last study"].ToString(); TU.Medical = a["Medical Done"].ToString(); TU.Refusal = a["Refusal"].ToString(); TU.Email = a["STUDENT E-MAIL ID"].ToString(); TU.Password = a["Password"].ToString(); TU.Fileno = "Jan/19"; db.StudentRegs.Add(TU); db.SaveChanges(); fees fee = new fees(); fee.studentid = TU.Fileno + "" + TU.RollNo; fee.Package = Convert.ToInt32(a["Package"]); fee.Advance = Convert.ToInt32(a["Advance"]); fee.pay = Convert.ToInt32(a["Advance"]); fee.balance = fee.Package - fee.pay; db.fees.Add(fee); db.SaveChanges(); // a.RollNo, a.StudentName, a.FatherName, a.Address, a.Contact, a.Laststudy, a.Medical, a.Refusal, a.Email, a.Password } else { //data.Add("<ul>"); //if (a.StudentName == "" || a.StudentName == null) data.Add("<li> name is required</li>"); //if (a.FatherName == "" || a.FatherName == null) data.Add("<li> Father Name is required</li>"); //if (a.Address == "" || a.Address == null) data.Add("<li> Address is required</li>"); //if (a.Contact == "" || a.Contact == null) data.Add("<li>ContactNo is required</li>"); data.Add("</ul>"); data.ToArray(); return(Json(data, JsonRequestBehavior.AllowGet)); } } catch (DbEntityValidationException ex) { foreach (var entityValidationErrors in ex.EntityValidationErrors) { foreach (var validationError in entityValidationErrors.ValidationErrors) { Response.Write("Property: " + validationError.PropertyName + " Error: " + validationError.ErrorMessage); } } } } //deleting excel file from folder if ((System.IO.File.Exists(pathToExcelFile))) { System.IO.File.Delete(pathToExcelFile); } // return RedirectToAction("Index"); return(Json("success", JsonRequestBehavior.AllowGet)); // return RedirectToAction("Index"); // Response.Redirect("Index"); } else { //alert message for invalid file format data.Add("<ul>"); data.Add("<li>Only Excel file format is allowed</li>"); data.Add("</ul>"); data.ToArray(); return(Json(data, JsonRequestBehavior.AllowGet)); } } else { data.Add("<ul>"); if (FileUpload == null) { data.Add("<li>Please choose Excel file</li>"); } data.Add("</ul>"); data.ToArray(); return(Json(data, JsonRequestBehavior.AllowGet)); } }