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