protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
Page.Validate();
if (!Page.IsValid)
{
return;
}
StudentReg stReg = new StudentReg(firstname.Text, lastname.Text);
StudentRepository.GetRepository().AddReg(stReg);
int mball = 0 + int.Parse(mbal.Text);
int hball = 0 + int.Parse(hbal.Text);
int rlanbal = 0 + int.Parse(rlan.Text);
try
{
StudentBall studentBall = new StudentBall(mball, hball, rlanbal);
stReg.StBll.Add(studentBall);
SampleContext context = new SampleContext();
context.StudentRegs.Add(stReg);
context.SaveChanges();
}
catch (Exception ex)
{
Response.Redirect("Ошибка " + ex.Message);
}
Response.Redirect("successfullyAdded.aspx");
}
}
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 DeleteConfirmed(int id)
{
StudentReg studentReg = db.StudentRegs.Find(id);
db.StudentRegs.Remove(studentReg);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Studentid,StudentName,FatherName,Address,Contact,Laststudy,Medical,Refusal,Email,Password")] StudentReg studentReg)
{
if (ModelState.IsValid)
{
studentReg.RollNo = regno;
studentReg.Fileno = "Jan/19";
db.Entry(studentReg).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(studentReg));
}
// GET: OfficialAdmin/StudentRegs/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StudentReg studentReg = db.StudentRegs.Find(id);
if (studentReg == null)
{
return(HttpNotFound());
}
return(View(studentReg));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["username"] == null)
{
Session["new"] = "Feedback";
Response.Redirect("LoginStudent.aspx");
}
StudList studList = new StudList();
StudListDAO studDAO = new StudListDAO();
StudentReg studReg = new StudentReg();
StudRegDAO regDAO = new StudRegDAO();
studList = studDAO.getRegbyStudAdmin(Session["Username"].ToString());
Lblno.Text = studList.studentAdmin.ToString();
studReg = regDAO.getTripID(Lblno.Text);
Lblcode.Text = studReg.TripID.ToString();
}
public static void RegisterStudent(StudentReg studentReg)
{
string gender = studentReg.Gender.HasValue ? studentReg.Gender.ToString() : null;
using (HELPSEntities ctx = new HELPSEntities())
{
ctx.prcCreateStudent(studentReg.StudentId, studentReg.DateOfBirth, gender, studentReg.Degree.ToString(),
studentReg.Status.ToString(), studentReg.FirstLanguage, studentReg.CountryOrigin,
studentReg.Background,
studentReg.HSC, studentReg.HSCMark, studentReg.IELTS, studentReg.IELTSMark,
studentReg.TOEFL, studentReg.TOEFLMark, studentReg.TAFE, studentReg.TAFEMark,
studentReg.CULT, studentReg.CULTMark, studentReg.InsearchDEEP, studentReg.InsearchDEEPMark,
studentReg.InsearchDiploma, studentReg.InsearchDiplomaMark, studentReg.FoundationCourse,
studentReg.FoundationCourseMark,
studentReg.CreatorId, studentReg.DegreeDetails, studentReg.AltContact, studentReg.PreferredName);
}
}
public IActionResult StudentReg(StudentRegViewModel model)
{
StudentReg student = new StudentReg
{
name = model.name,
cls = model.cls,
dept = model.dept,
roll = model.roll,
father = model.father,
mother = model.mother,
mobile = model.mobile,
email = model.email,
present = model.present,
parmanent = model.parmanent
};
_context.StudentRegs.Add(student);
_context.SaveChanges();
return(View());
}
// GET: OfficialAdmin/SingleFees/Create
public ActionResult Create(int id, SingleFee single2)
{
StudentReg stu = db.StudentRegs.Find(id);
TempData["stuid"] = stu.Fileno + "" + stu.RollNo;
TempData["id"] = stu.Studentid;
regno = TempData["stuid"].ToString();
var single = db.SingleFees.FirstOrDefault();
if (single == null)
{
single2.Billno = Convert.ToInt32(100);
}
else
{
var single3 = db.SingleFees.Max(x => x.Billno);
single2.Billno = single3 + 1;
}
// single2.studentid = TempData["stuid"].ToString();
return(View(single2));
}
public Response RegisterStudent(StudentReg studentReg)
{
try
{
base.CheckApplicationKey();
StudentDb.RegisterStudent(studentReg);
}
catch (Exception e)
{
string msg = CreateExceptionMessage(e);
return new Response()
{
IsSuccess = false,
DisplayMessage = string.Format(ErrorMessages.STUDENT_REGISTER_ERROR, msg)
};
}
return new Response()
{
IsSuccess = true
};
}
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));
}
}
public void AddReg(StudentReg stlist)
{
stlists.Add(stlist);
}
