public ActionResult Edit([Bind(Include = "ROLE_ID,role_name,role_created_date")] NBA_Role nBA_Role)
{
if (ModelState.IsValid)
{
db.Entry(nBA_Role).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(nBA_Role));
}
public ActionResult Edit([Bind(Include = "ID,PR_SR_ID,PR_name,SR_name,province,district,subdistrict,date_entered")] NBA_PR nBA_PR)
{
if (ModelState.IsValid)
{
db.Entry(nBA_PR).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(nBA_PR));
}
public ActionResult Edit([Bind(Include = "SYS_USER_ID,name,surname,username,password,mobile,employee_id,organization,province,district,subdistrict,image,SR_name,Entry_ID,email,sys_IsEmailVerified,sys_VerificationCode,reg_date,last_updated,last_login,ROLE_ID,ID")] NBA_SYS_Users nBA_SYS_Users)
{
if (ModelState.IsValid)
{
db.Entry(nBA_SYS_Users).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ROLE_ID = new SelectList(db.NBA_Role, "ROLE_ID", "role_name", nBA_SYS_Users.ROLE_ID);
ViewBag.ID = new SelectList(db.NBA_PR, "ID", "PR_SR_ID", nBA_SYS_Users.ID);
return(View(nBA_SYS_Users));
}
public ActionResult Edit([Bind(Include = "AGWY_ID,name,surname,known_as,gender,race,type_of_identification,idno,dateOfbirth,place_of_birth,maiden_name,address,town_village,uic,email,phone_number,alternative__number,alternative_number_relationship,attended_school,name_of_school,higest_grade_passed,currrent_occupation,safe_place,approval_flag,concent_flag,mimetype,imagedata,home_language,reg_date,last_updated,last_login,status,ID,SEMESTER_ID,SYS_USER_ID,DOCUMENT_ID,RISK_ID,Core_ID")] NBA_Agwy nBA_Agwy)
{
if (ModelState.IsValid)
{
db.Entry(nBA_Agwy).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Core_ID = new SelectList(db.NBA_Core, "CORE_ID", "description", nBA_Agwy.Core_ID);
ViewBag.DOCUMENT_ID = new SelectList(db.NBA_Documents, "DOCUMENT_ID", "doc_name", nBA_Agwy.DOCUMENT_ID);
ViewBag.RISK_ID = new SelectList(db.NBA_RiskAssessment, "RISK_ID", "risk_description", nBA_Agwy.RISK_ID);
ViewBag.SEMESTER_ID = new SelectList(db.NBA_SemesterMaintenance, "SEMESTER_ID", "semester_name", nBA_Agwy.SEMESTER_ID);
ViewBag.ID = new SelectList(db.NBA_PR, "ID", "PR_SR_ID", nBA_Agwy.ID);
return(View(nBA_Agwy));
}
// public ActionResult Edit([Bind(Include = "AGWY_ID,name,surname,known_as,gender,race,type_of_identification,idno,dateOfbirth,place_of_birth,maiden_name,address,town_village,uic,email,phone_number,alternative_number,alternative_number_relationship,attended_school,name_of_school,higest_grade_passed,currrent_occupation,approval_flag,concent_flag,mimetype,imagedata,home_language,reg_date,last_updated,last_login,status,ID,SEMESTER_ID,SYS_USER_ID,DOCUMENT_ID,Core_ID,messageInquiry,EntryPoint_ID,HighSchoolQuizz_ID,RISK_ID")] NBA_Agwy nBA_Agwy)
public ActionResult Edit(NBA_Agwy nBA_Agwy)
{
if (ModelState.IsValid)
{
//db.Entry(nBA_Agwy).State = EntityState.Modified;
//db.SaveChanges();
//return RedirectToAction("Index");
var db = new nlbdataEntities1();
//string dateofbirth=nBA_Agwy.dateOfbirth
DateTime dob = Convert.ToDateTime(nBA_Agwy.dateOfbirth);
string day = dob.ToString("dd/MM/yyyy");
//string day = dob.ToString();
//string day = nBA_Agwy.dateOfbirth.ToString();
//string uuic = nBA_Agwy.name.Substring(0, 2) + nBA_Agwy.maiden_name.Substring(0, 3) + nBA_Agwy.dateOfbirth.ToString().Substring(0, 8);
string uuic = nBA_Agwy.name.Substring(0, 2) + nBA_Agwy.maiden_name.Substring(0, 3) + day.Substring(0, 2) + day.Substring(3, 2) + nBA_Agwy.town_village.Substring(0, 3);
//r dbuic = db.NBA_Agwy.Where(x => x.uic.Substring(0, 15) == uuic).Select( n1 => n1.uic).FirstOrDefault();
//ar uic = db.NBA_Agwy.Where(x => x.uic.Substring(0, 15) == uuic).Select(n1 => n1.uic).FirstOrDefault();
//r uic1=(from var in db.NBA_Agwy where var.uic == nBA_Agwy.uic).select var.uic;
//uic1.FirstOrDefault();
//tring dbui1 = dbuic.ToString();
var uiccount = db.NBA_Agwy.Where(x => x.uic == uuic).Select(n3 => n3.uic).Count();
int uiccounting = uiccount;
if (uiccounting <= 1)
{
var uiccount1 = db.NBA_Agwy.Where(x => x.uic.Substring(0, 12) == uuic).Select(n3 => n3.uic).Count();
uiccounting = uiccount1;
}
// NBA_Agwy n = new NBA_Agwy();
NBA_Agwy n = db.NBA_Agwy.Where(x => x.AGWY_ID == nBA_Agwy.AGWY_ID).SingleOrDefault();
{
n.name = nBA_Agwy.name;
n.surname = nBA_Agwy.surname;
n.known_as = nBA_Agwy.known_as;
n.gender = nBA_Agwy.gender;
//n.age = nBA_Agwy.age;
n.type_of_identification = nBA_Agwy.type_of_identification;
n.idno = nBA_Agwy.idno;
n.reg_date = DateTime.Today;
int useridsession = Convert.ToInt32(Session["UseriD"]);
n.SYS_USER_ID = useridsession;
n.house_number = nBA_Agwy.house_number;
n.street_name = nBA_Agwy.street_name;
n.town_village_address = nBA_Agwy.town_village_address;
n.describe_living = nBA_Agwy.describe_living;
n.dateOfbirth = nBA_Agwy.dateOfbirth;
n.maiden_name = nBA_Agwy.maiden_name;
n.name_of_school = nBA_Agwy.name_of_school;
n.alternative_number = nBA_Agwy.alternative_number;
n.alternative_number_relationship = nBA_Agwy.alternative_number_relationship;
n.attended_school = nBA_Agwy.attended_school;
n.currrent_occupation = nBA_Agwy.currrent_occupation;
n.email = nBA_Agwy.email;
n.EntryPoint_ID = nBA_Agwy.EntryPoint_ID;
n.higest_grade_passed = nBA_Agwy.higest_grade_passed;
n.HighSchoolQuizz_ID = nBA_Agwy.HighSchoolQuizz_ID;
n.known_as = nBA_Agwy.known_as;
n.messageInquiry = nBA_Agwy.messageInquiry;
n.NBA_Grade = nBA_Agwy.NBA_Grade;
n.NBA_Identification = nBA_Agwy.NBA_Identification;
n.ID = nBA_Agwy.ID;
n.town_village = nBA_Agwy.town_village;
n.NBA_Occupation = nBA_Agwy.NBA_Occupation;
//DateTime today = today();
string today = DateTime.Now.ToString("dd/MM/yyyy").Substring(6, 4);
// string today = DateTime.Now.ToString().Substring(6, 4);
//string day = dob.ToString("dd/MM/yyyy");
string srtyear = day.Substring(6, 4);
int age = Convert.ToInt32(today) - Convert.ToInt32(srtyear);
n.age = age.ToString();
if (uiccounting > 1 || uiccounting == 1)
{
if (uiccounting < 9)
{
n.uic = nBA_Agwy.name.Substring(0, 2) + nBA_Agwy.maiden_name.Substring(0, 3) + day.Substring(0, 2) + day.Substring(3, 2) + nBA_Agwy.town_village.Substring(0, 3) + "0" + (1 + uiccount).ToString();
}
else
{
n.uic = nBA_Agwy.name.Substring(0, 2) + nBA_Agwy.maiden_name.Substring(0, 3) + day.Substring(0, 2) + day.Substring(3, 2) + nBA_Agwy.town_village.Substring(0, 3) + (1 + uiccount).ToString();
}
}
else
{
n.uic = nBA_Agwy.name.Substring(0, 2) + nBA_Agwy.maiden_name.Substring(0, 3) + day.Substring(0, 2) + day.Substring(3, 2) + nBA_Agwy.town_village.Substring(0, 3);
}
}
db.Entry(n).State = EntityState.Modified;
//db.SaveChanges();
//db.NBA_Agwy.Add(n);
db.SaveChanges();
ModelState.Clear();
return(RedirectToAction("Index"));
}
ViewBag.Core_ID = new SelectList(db.NBA_Core, "CORE_ID", "description", nBA_Agwy.Core_ID);
ViewBag.DOCUMENT_ID = new SelectList(db.NBA_Documents, "DOCUMENT_ID", "doc_name", nBA_Agwy.DOCUMENT_ID);
ViewBag.EntryPoint_ID = new SelectList(db.NBA_Entry_Points, "ENTRY_ID", "description", nBA_Agwy.EntryPoint_ID);
ViewBag.gender = new SelectList(db.NBA_Gender, "GenderID", "GenderType", nBA_Agwy.gender);
ViewBag.higest_grade_passed = new SelectList(db.NBA_Grade, "Grade_ID", "Description", nBA_Agwy.higest_grade_passed);
ViewBag.HighSchoolQuizz_ID = new SelectList(db.NBA_HighSchoolQuizz, "HighSchoolQuiz_ID", "Description", nBA_Agwy.HighSchoolQuizz_ID);
ViewBag.type_of_identification = new SelectList(db.NBA_Identification, "Identification_ID", "Description", nBA_Agwy.type_of_identification);
ViewBag.messageInquiry = new SelectList(db.NBA_MessageID, "MessageID", "Description", nBA_Agwy.messageInquiry);
ViewBag.currrent_occupation = new SelectList(db.NBA_Occupation, "Occupation_ID", "Description", nBA_Agwy.currrent_occupation);
ViewBag.RISK_ID = new SelectList(db.NBA_RiskAssessment, "RISK_ID", "risk_description", nBA_Agwy.RISK_ID);
ViewBag.SEMESTER_ID = new SelectList(db.NBA_SemesterMaintenance, "SEMESTER_ID", "semester_name", nBA_Agwy.SEMESTER_ID);
ViewBag.ID = new SelectList(db.NBA_PR, "ID", "PR_SR_ID", nBA_Agwy.ID);
return(View(nBA_Agwy));
}