public ActionResult Edit(StudentAddressVM viewModel)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
Entities.StudentAddress entity = new Entities.StudentAddress();
entity.StudentId = viewModel.StudentId;
entity.CurrentAddress = viewModel.CurrentAddress;
entity.CurrentCountryId = viewModel.CurrentCountryId;
entity.CurrentStateId = viewModel.CurrentStateId;
entity.CurrentDistrictId = viewModel.CurrentDistrictId;
entity.CurrentCityId = viewModel.CurrentCityId;
entity.CurrentPinCode = viewModel.CurrentPinCode;
entity.PermentAddress = viewModel.PermentAddress;
entity.PermentCountryId = viewModel.PermentCountryId;
entity.PermentStateId = viewModel.PermentStateId;
entity.PermentDistrictId = viewModel.PermentDistrictId;
entity.PermentCityId = viewModel.PermentCityId;
entity.PermentPinCode = viewModel.PermentPinCode;
entity.Status = viewModel.Status;
entity.Remark = viewModel.Remark;
StudentAddressBAL balObject = new StudentAddressBAL();
IQueryable <Entities.StudentAddress> studentAddresses = balObject.FindBy(s => s.StudentId == viewModel.StudentId);
if (studentAddresses != null && studentAddresses.Count() > 0)
{
balObject.Edit(entity);
}
else
{
balObject.Add(entity);
}
return(RedirectToAction("Index", "Student"));
}
else
{
CountryBAL countryBAL = new CountryBAL();
viewModel.Countries = from obj in countryBAL.GetAll().Where(c => c.Status == true) select new SelectListItem()
{
Text = obj.CountryName, Value = obj.CountryId.ToString()
};
return(View(viewModel));
}
}
catch
{
CountryBAL countryBAL = new CountryBAL();
viewModel.Countries = from obj in countryBAL.GetAll().Where(c => c.Status == true) select new SelectListItem()
{
Text = obj.CountryName, Value = obj.CountryId.ToString()
};
return(View());
}
}
public ActionResult Select()
{
string mode = Request.QueryString["Grid-mode"];
if (!string.IsNullOrEmpty(mode))
{
return(this.RedirectToAction("Create"));
}
else
{
List <CountryVM> viewModels = new List <CountryVM>();
CountryBAL balObject = new CountryBAL();
IQueryable <Entities.Country> entites = balObject.GetAll();
foreach (Entities.Country entity in entites)
{
CountryVM viewModel = new CountryVM();
viewModel.CountryId = entity.CountryId;
viewModel.CountryName = entity.CountryName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
viewModels.Add(viewModel);
}
return(this.View("Index", new GridModel <CountryVM> {
Data = viewModels
}));
}
}
public ActionResult Select()
{
string mode = Request.QueryString["Grid-mode"];
if (!string.IsNullOrEmpty(mode))
{
return(this.RedirectToAction("Create"));
}
else
{
List <StateVM> viewModels = new List <StateVM>();
StateBAL balObject = new StateBAL();
IQueryable <Entities.State> entites = balObject.GetAll();
CountryBAL countryBAL = new CountryBAL();
IQueryable <Entities.Country> countries = countryBAL.GetAll();
foreach (Entities.State entity in entites)
{
StateVM viewModel = new StateVM();
viewModel.StateId = entity.StateId;
viewModel.StateName = entity.StateName;
viewModel.CountryName = countries.Where(c => c.CountryId == entity.CountryId).FirstOrDefault().CountryName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
viewModels.Add(viewModel);
}
return(View(new GridModel <StateVM> {
Data = viewModels
}));
}
}
public ActionResult Create(CountryVM viewModel)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
Entities.Country entity = new Entities.Country();
entity.CountryId = viewModel.CountryId;
entity.CountryName = viewModel.CountryName;
entity.Status = viewModel.Status;
entity.Remark = viewModel.Remark;
CountryBAL balObject = new CountryBAL();
balObject.Add(entity);
return(RedirectToAction("Index"));
}
else
{
//AcademicYearBAL academicYearBAL = new AcademicYearBAL();
// viewModel.AcademicYears = from obj in academicYearBAL.GetAll() select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() };
return(View(viewModel));
}
}
catch
{
//AcademicYearBAL academicYearBAL = new AcademicYearBAL();
// viewModel.AcademicYears = from obj in academicYearBAL.GetAll() select new SelectListItem() { Text = obj.AcademicYearName, Value = obj.AcademicYearId.ToString() };
return(View(viewModel));
}
}
public ActionResult Edit(CountryVM viewModel)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
Entities.Country entity = new Entities.Country();
entity.CountryId = viewModel.CountryId;
entity.CountryName = viewModel.CountryName;
entity.Status = viewModel.Status;
entity.Remark = viewModel.Remark;
CountryBAL balObject = new CountryBAL();
balObject.Edit(entity);
return(RedirectToAction("Index"));
}
else
{
return(View(viewModel));
}
}
catch
{
return(View());
}
}
public ActionResult Index()
{
List <StudentAddressVM> viewModels = new List <StudentAddressVM>();
StudentAddressBAL balObject = new StudentAddressBAL();
IQueryable <Entities.StudentAddress> entites = balObject.GetAll();
CountryBAL countryBAL = new CountryBAL();
IQueryable <Entities.Country> countries = countryBAL.GetAll();
StateBAL stateBAL = new StateBAL();
IQueryable <Entities.State> states = stateBAL.GetAll();
DistrictBAL DistrictObject = new DistrictBAL();
IQueryable <Entities.District> districts = DistrictObject.GetAll();
CityBAL CityObject = new CityBAL();
IQueryable <Entities.City> cities = CityObject.GetAll();
StudentBAL studentObject = new StudentBAL();
IQueryable <Entities.Student> students = studentObject.GetAll();
foreach (Entities.StudentAddress entity in entites)
{
StudentAddressVM viewModel = new StudentAddressVM();
viewModel.StudentId = entity.StudentId;
viewModel.CurrentAddress = entity.CurrentAddress;
viewModel.CurrentCountryId = entity.CurrentCountryId;
viewModel.CurrentStateId = entity.CurrentStateId;
viewModel.CurrentDistrictId = entity.CurrentDistrictId;
viewModel.CurrentCityId = entity.CurrentCityId;
viewModel.CurrentCountryName = countries.Where(c => c.CountryId == entity.CurrentCountryId).FirstOrDefault().CountryName;
viewModel.CurrentStateName = states.Where(s => s.StateId == entity.CurrentStateId).FirstOrDefault().StateName;
viewModel.CurrentDistrictName = districts.Where(c => c.DistrictId == entity.CurrentDistrictId).FirstOrDefault().DistrictName;
viewModel.CurrentCityName = cities.Where(c => c.CityId == entity.CurrentDistrictId).FirstOrDefault().CityName;
viewModel.PermentAddress = entity.PermentAddress;
viewModel.PermentCountryId = entity.PermentCountryId;
viewModel.PermentStateId = entity.PermentStateId;
viewModel.PermentDistrictId = entity.PermentDistrictId;
viewModel.PermentCityId = entity.PermentCityId;
viewModel.PermentCountryName = countries.Where(c => c.CountryId == entity.PermentCountryId).FirstOrDefault().CountryName;
viewModel.PermentStateName = states.Where(s => s.StateId == entity.PermentStateId).FirstOrDefault().StateName;
viewModel.PermentDistrictName = districts.Where(c => c.DistrictId == entity.PermentDistrictId).FirstOrDefault().DistrictName;
viewModel.PermentCityName = cities.Where(c => c.CityId == entity.PermentCityId).FirstOrDefault().CityName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
Entities.Student student = students.Where(s => s.StudentId == entity.StudentId).FirstOrDefault();
viewModel.StudentFullNameWithTitle = string.Concat(student.Title, " ", student.FirstName, " ", student.MiddleName, " ", student.LastName);
viewModels.Add(viewModel);
}
return(View(new GridModel <StudentAddressVM> {
Data = viewModels
}));
}
protected void btnSave_Click(object sender, EventArgs e)
{
#region Server Side Validation
lblError.Text = "";
if (txtCountryName.Text.Trim().ToUpper() == "")
{
lblError.Text += "Enter Country Name <br/>";
}
if (txtCountryCode.Text.Trim().ToUpper() == "")
{
lblError.Text += "Enter Country Code <br/>";
}
if (lblError.Text != "")
{
return;
}
#endregion Server Side Validation
#region Collecting Data
CountryENT entCountry = new CountryENT();
if (txtCountryCode.Text.Trim().ToUpper() != "" && txtCountryName.Text.Trim().ToUpper() != "")
{
entCountry.CountryName = txtCountryName.Text.Trim().ToUpper();
entCountry.CountryCode = txtCountryCode.Text.Trim().ToUpper();
}
CountryBAL balCountry = new CountryBAL();
#endregion Collecting Data
if (Request.QueryString["CountryID"] == null)
{
#region insertingData
if (balCountry.Insert(entCountry))
{
Response.Redirect("~/AdminPanel/Country/CountryList.aspx");
}
else
{
lblError.Text = balCountry.Message;
}
#endregion insertingData
}
else
{
#region updatingData
entCountry.CountryID = Convert.ToInt32(Request.QueryString["CountryID"]);
if (balCountry.Update(entCountry))
{
Response.Redirect("~/AdminPanel/Country/CountryList.aspx");
}
else
{
lblError.Text = balCountry.Message;
}
#endregion updatingData
}
}
public static void FillDropDownListCountry(DropDownList ddl)
{
CountryBAL balCountry = new CountryBAL();
ddl.DataSource = balCountry.SelectForDropdownList();
ddl.DataValueField = "CountryID";
ddl.DataTextField = "CountryName";
ddl.DataBind();
ddl.Items.Insert(0, new ListItem("Select Item", "-1"));
}
/// <summary>
/// method for get countries list
/// </summary>
/// <returns>countries list</returns>
public JsonResult GetCountriesList()
{
CountryBAL countryBAL = new CountryBAL();
var countriesList = from obj in countryBAL.GetAll().Where(c => c.Status == true) select new SelectListItem()
{
Text = obj.CountryName, Value = obj.CountryId.ToString()
};
return(this.Json(countriesList, JsonRequestBehavior.AllowGet));
}
//
// GET: /SysAdmin/Student/Edit/5
public ActionResult Edit(int id)
{
StudentAddressVM viewModel = new StudentAddressVM();
CountryBAL countryBAL = new CountryBAL();
viewModel.Countries = from obj in countryBAL.GetAll().Where(c => c.Status == true) select new SelectListItem()
{
Text = obj.CountryName, Value = obj.CountryId.ToString()
};
//Get Student Id
StudentBAL balStudentObject = new StudentBAL();
IQueryable <Entities.Student> studentEntities = balStudentObject.FindBy(s => s.SrNo == id);
if (studentEntities != null && studentEntities.Count() > 0)
{
Entities.Student studentEnity = studentEntities.FirstOrDefault();
viewModel.StudentId = studentEnity.StudentId;
viewModel.StudentFullNameWithTitle = string.Concat(studentEnity.Title.Trim(), " ", studentEnity.FirstName.Trim(), " ", studentEnity.MiddleName.Trim(), " ", studentEnity.LastName).Trim();
viewModel.Status = true;
}
StudentAddressBAL balObject = new StudentAddressBAL();
IQueryable <Entities.StudentAddress> entites = balObject.GetAll(viewModel.StudentId);
if (entites != null && entites.Count() > 0)
{
Entities.StudentAddress entity = entites.FirstOrDefault();
//viewModel.StudentId = entity.StudentId;
//viewModel.StudentFullNameWithTitle = entity.StudentFullName;
viewModel.CurrentAddress = entity.CurrentAddress;
viewModel.CurrentCountryId = entity.CurrentCountryId;
viewModel.CurrentStateId = entity.CurrentStateId;
viewModel.CurrentDistrictId = entity.CurrentDistrictId;
viewModel.CurrentCityId = entity.CurrentCityId;
viewModel.PermentAddress = entity.PermentAddress;
viewModel.PermentCountryId = entity.PermentCountryId;
viewModel.PermentStateId = entity.PermentStateId;
viewModel.PermentDistrictId = entity.PermentDistrictId;
viewModel.PermentCityId = entity.PermentCityId;
viewModel.CurrentPinCode = entity.CurrentPinCode;
viewModel.PermentPinCode = entity.PermentPinCode;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
}
//else
//{
// viewModel.StudentId = id;
// viewModel.StudentFullNameWithTitle = PresentationLayer.Other.CommanMethods.GetStudentName(id);
// viewModel.Status = true;
//}
return(View(viewModel));
}
private void FillGridViewCountry()
{
CountryBAL balCountry = new CountryBAL();
DataTable dtCountry = new DataTable();
dtCountry = balCountry.SelectAll();
if (dtCountry != null && dtCountry.Rows.Count > 0)
{
gvCountryList.DataSource = dtCountry;
gvCountryList.DataBind();
}
}
//
// GET: /SysAdmin/Student/Create
public ActionResult Create()
{
StudentAddressVM viewModel = new StudentAddressVM();
CountryBAL countryBAL = new CountryBAL();
viewModel.Countries = from obj in countryBAL.GetAll().Where(c => c.Status == true) select new SelectListItem()
{
Text = obj.CountryName, Value = obj.CountryId.ToString()
};
viewModel.Status = true;
return(View(viewModel));
}
//
// POST: /SysAdmin/Country/Delete/5
//[HttpPost]
public ActionResult Delete(int id)
{
try
{
// TODO: Add delete logic here
CountryBAL balObject = new CountryBAL();
balObject.Delete(id);
return(RedirectToAction("Index"));
}
catch
{
return(View());
}
}
protected void gvCountryList_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandArgument != null)
{
CountryBAL balCountry = new CountryBAL();
if (balCountry.Delete(Convert.ToInt32(e.CommandArgument.ToString().Trim())))
{
Response.Redirect("~/Adminpanel/Country/CountryList.aspx");
lblError.Text = "";
}
else
{
lblError.Text = balCountry.Message;
}
}
}
//
// GET: /SysAdmin/Country/Details/5
public ActionResult Details(int id)
{
CountryVM viewModel = new CountryVM();
CountryBAL balObject = new CountryBAL();
IQueryable <Entities.Country> entites = balObject.FindBy(a => a.CountryId == id);
if (entites != null && entites.Count() > 0)
{
Entities.Country entity = entites.FirstOrDefault();
viewModel.CountryId = entity.CountryId;
viewModel.CountryName = entity.CountryName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
}
return(View(viewModel));
}
public ActionResult Create(StudentAddressVM viewModel)
{
try
{
// TODO: Add insert logic here
if (ModelState.IsValid)
{
Entities.StudentAddress entity = new Entities.StudentAddress();
entity.StudentId = viewModel.StudentId;
entity.CurrentAddress = viewModel.CurrentAddress;
entity.CurrentCountryId = viewModel.CurrentCountryId;
entity.CurrentStateId = viewModel.CurrentStateId;
entity.CurrentDistrictId = viewModel.CurrentDistrictId;
entity.CurrentCityId = viewModel.CurrentCityId;
entity.PermentAddress = viewModel.PermentAddress;
entity.PermentCountryId = viewModel.PermentCountryId;
entity.PermentStateId = viewModel.PermentStateId;
entity.PermentDistrictId = viewModel.PermentDistrictId;
entity.PermentCityId = viewModel.PermentCityId;
entity.Status = viewModel.Status;
entity.Remark = viewModel.Remark;
StudentAddressBAL balObject = new StudentAddressBAL();
balObject.Add(entity);
return(RedirectToAction("Index"));
}
else
{
CountryBAL countryBAL = new CountryBAL();
viewModel.Countries = from obj in countryBAL.GetAll().Where(c => c.Status == true) select new SelectListItem()
{
Text = obj.CountryName, Value = obj.CountryId.ToString()
};
return(View(viewModel));
}
}
catch
{
CountryBAL countryBAL = new CountryBAL();
viewModel.Countries = from obj in countryBAL.GetAll().Where(c => c.Status == true) select new SelectListItem()
{
Text = obj.CountryName, Value = obj.CountryId.ToString()
};
return(View(viewModel));
}
}
public ActionResult Index()
{
List <CountryVM> viewModels = new List <CountryVM>();
CountryBAL balObject = new CountryBAL();
IQueryable <Entities.Country> entites = balObject.GetAll();
foreach (Entities.Country entity in entites)
{
CountryVM viewModel = new CountryVM();
viewModel.CountryId = entity.CountryId;
viewModel.CountryName = entity.CountryName;
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
viewModels.Add(viewModel);
}
return(View(new GridModel <CountryVM> {
Data = viewModels
}));
}
private void fillControls(SqlInt32 CountryID)
{
CountryENT entCountry = new CountryENT();
CountryBAL balCountry = new CountryBAL();
entCountry = balCountry.SelectByPK(CountryID);
if (entCountry != null)
{
if (!entCountry.CountryName.IsNull)
{
txtCountryName.Text = entCountry.CountryName.Value.ToString();
}
if (!entCountry.CountryCode.IsNull)
{
txtCountryCode.Text = entCountry.CountryCode.Value.ToString();
}
}
else
{
lblError.Text = balCountry.Message;
}
}
public ActionResult Edit(StudentParentVM viewModel)
{
try
{
// TODO: Add update logic here
if (ModelState.IsValid)
{
Entities.StudentParent entity = new Entities.StudentParent();
entity.StudentId = viewModel.StudentId;
entity.Title = viewModel.Title;
entity.FirstName = viewModel.FirstName;
entity.MiddleName = viewModel.MiddleName;
entity.LastName = viewModel.LastName;
entity.Gender = viewModel.Gender;
entity.Address = viewModel.CurrentAddress;
entity.CountryId = viewModel.CurrentCountryId;
entity.StateId = viewModel.CurrentStateId;
entity.DistrictId = viewModel.CurrentDistrictId;
entity.CityId = viewModel.CurrentCityId;
entity.PinCode = viewModel.CurrentPinCode.HasValue ? Convert.ToInt32(viewModel.CurrentPinCode) : 0;
entity.MobileNumber = viewModel.MobileNo;
entity.ContactNo = viewModel.ContactNumber;
entity.Occupation = viewModel.Occupation;
entity.CompanyName = viewModel.CompanyName;
entity.CompanyAddress = viewModel.CompanyAddress;
entity.CompanyContactNo = viewModel.CompanyContactNo;
entity.BankName = string.IsNullOrEmpty(viewModel.BankName) ? string.Empty : viewModel.BankName.Trim();
entity.AccountNo = string.IsNullOrEmpty(viewModel.AccountNo) ? string.Empty : viewModel.AccountNo.Trim();
entity.Branch = string.IsNullOrEmpty(viewModel.Branch) ? string.Empty : viewModel.Branch.Trim();
entity.IFSCCode = string.IsNullOrEmpty(viewModel.IFSCCode) ? string.Empty : viewModel.IFSCCode.Trim();
entity.Status = viewModel.Status;
entity.Remark = viewModel.Remark;
StudentParentBAL balObject = new StudentParentBAL();
IQueryable <Entities.StudentParent> StudentParents = balObject.FindBy(s => s.StudentId == viewModel.StudentId);
if (StudentParents != null && StudentParents.Count() > 0)
{
balObject.Edit(entity);
}
else
{
balObject.Add(entity);
}
return(RedirectToAction("Index", "Student"));
}
else
{
CountryBAL countryBAL = new CountryBAL();
viewModel.Countries = from obj in countryBAL.GetAll().Where(c => c.Status == true) select new SelectListItem()
{
Text = obj.CountryName, Value = obj.CountryId.ToString()
};
return(View(viewModel));
}
}
catch
{
CountryBAL countryBAL = new CountryBAL();
viewModel.Countries = from obj in countryBAL.GetAll().Where(c => c.Status == true) select new SelectListItem()
{
Text = obj.CountryName, Value = obj.CountryId.ToString()
};
return(View());
}
}
//
// GET: /SysAdmin/Student/Edit/5
public ActionResult Edit(int id)
{
StudentParentVM viewModel = new StudentParentVM();
CountryBAL countryBAL = new CountryBAL();
viewModel.Countries = from obj in countryBAL.GetAll().Where(c => c.Status == true) select new SelectListItem()
{
Text = obj.CountryName, Value = obj.CountryId.ToString()
};
//Get Student Id
StudentBAL balStudentObject = new StudentBAL();
IQueryable <Entities.Student> studentEntities = balStudentObject.FindBy(s => s.SrNo == id);
if (studentEntities != null && studentEntities.Count() > 0)
{
Entities.Student studentEnity = studentEntities.FirstOrDefault();
viewModel.StudentId = studentEnity.StudentId;
viewModel.StudentFullNameWithTitle = string.Concat(studentEnity.Title.Trim(), " ", studentEnity.FirstName.Trim(), " ", studentEnity.MiddleName.Trim(), " ", studentEnity.LastName).Trim();
viewModel.Status = true;
}
StudentParentBAL balObject = new StudentParentBAL();
IQueryable <Entities.StudentParent> entites = balObject.FindBy(a => a.StudentId == viewModel.StudentId);
if (entites != null && entites.Count() > 0)
{
Entities.StudentParent entity = entites.FirstOrDefault();
viewModel.Title = entity.Title.Trim();
viewModel.FirstName = entity.FirstName.Trim();
viewModel.MiddleName = entity.MiddleName.Trim();
viewModel.LastName = entity.LastName.Trim();
viewModel.Gender = entity.Gender.Trim();
viewModel.CurrentAddress = entity.Address.Trim();
viewModel.CurrentCountryId = entity.CountryId;
viewModel.CurrentStateId = entity.StateId;
viewModel.CurrentDistrictId = entity.DistrictId;
viewModel.CurrentCityId = entity.CityId;
viewModel.CurrentPinCode = entity.PinCode;
viewModel.MobileNo = entity.MobileNumber;
viewModel.ContactNumber = entity.ContactNo;
viewModel.Occupation = entity.Occupation.Trim();
viewModel.CompanyName = entity.CompanyName.Trim();
viewModel.CompanyAddress = entity.CompanyAddress.Trim();
viewModel.CompanyContactNo = entity.CompanyContactNo.Trim();
viewModel.BankName = entity.BankName.Trim();
viewModel.AccountNo = entity.AccountNo.Trim();
viewModel.Branch = entity.Branch.Trim();
viewModel.IFSCCode = entity.IFSCCode.Trim();
// viewModel.StudentFullNameWithTitle = entity.StudentFullName.Trim();
viewModel.Status = entity.Status;
viewModel.Remark = entity.Remark;
}
//else
//{
// viewModel.StudentFullNameWithTitle = PresentationLayer.Other.CommanMethods.GetStudentName(id);
// viewModel.Status = true;
//}
return(View(viewModel));
}
private DataSet LeavingCertificate(int StudentId)
{
DataSet ds = new DataSet();
ds.DataSetName = "DataSourceForReport";
DataTable dt = new DataTable("LeavingCertificate");
dt.TableName = "LeavingCertificate";
dt.Columns.Add(new DataColumn("StudentId", typeof(string)));
dt.Columns.Add(new DataColumn("FirstName", typeof(string)));
dt.Columns.Add(new DataColumn("MiddleName", typeof(string)));
dt.Columns.Add(new DataColumn("LastName", typeof(string)));
dt.Columns.Add(new DataColumn("MotherName", typeof(string)));
dt.Columns.Add(new DataColumn("MotherTounge", typeof(string)));
dt.Columns.Add(new DataColumn("ReligionName", typeof(string)));
dt.Columns.Add(new DataColumn("CastName", typeof(string)));
dt.Columns.Add(new DataColumn("SubCast", typeof(string)));
dt.Columns.Add(new DataColumn("Nationality", typeof(string)));
dt.Columns.Add(new DataColumn("PlaceOfBirth", typeof(string)));
dt.Columns.Add(new DataColumn("DateOfBirth", typeof(DateTime)));
dt.Columns.Add(new DataColumn("DateOfBirthInWord", typeof(string)));
dt.Columns.Add(new DataColumn("LastSchool", typeof(string)));
dt.Columns.Add(new DataColumn("DateOfAdmission", typeof(DateTime)));
dt.Columns.Add(new DataColumn("Progress", typeof(string)));
dt.Columns.Add(new DataColumn("Conduct", typeof(string)));
dt.Columns.Add(new DataColumn("DateOfLeaveingSchool", typeof(DateTime)));
dt.Columns.Add(new DataColumn("ClassInWhichStudingAndSinceWhen", typeof(string)));
dt.Columns.Add(new DataColumn("Reason", typeof(string)));
dt.Columns.Add(new DataColumn("Remark", typeof(string)));
dt.Columns.Add(new DataColumn("RegisterNo", typeof(int)));
dt.Columns.Add(new DataColumn("TCNo", typeof(string)));
dt.Columns.Add(new DataColumn("TCPrinted", typeof(bool)));
dt.Columns.Add(new DataColumn("AdharcardNo", typeof(string)));
dt.Columns.Add(new DataColumn("DateOfLeaveingSchoolInWords", typeof(string)));
dt.Columns.Add(new DataColumn("Taluka", typeof(string)));
dt.Columns.Add(new DataColumn("District", typeof(string)));
dt.Columns.Add(new DataColumn("state", typeof(string)));
dt.Columns.Add(new DataColumn("Country", typeof(string)));
int studentId = (int)PresentationLayer.Helpers.SessionHelper.StudentId;
// Fetch the District, State, Country from database ***********
string strDistrict, strState, strCountry, strCity;
strDistrict = strState = strCountry = strCity = "";
//balObject.FindBy(s => s.StudentId == studentId );
StudentParentBAL balObjectAddr = new StudentParentBAL();
IQueryable <Entities.StudentParent> entites1 = balObjectAddr.FindBy(s => s.StudentId == studentId);
if (entites1 != null && entites1.Count() > 0)
{
Entities.StudentParent entity1 = entites1.FirstOrDefault();
CountryBAL countryBAL = new CountryBAL();
IQueryable <Entities.Country> countries = countryBAL.GetAll();
StateBAL stateBAL = new StateBAL();
IQueryable <Entities.State> states = stateBAL.GetAll();
DistrictBAL DistrictObject = new DistrictBAL();
IQueryable <Entities.District> District = DistrictObject.GetAll();
CityBAL CityObject = new CityBAL();
IQueryable <Entities.City> Cities = CityObject.GetAll();
strCountry = countries.Where(c => c.CountryId == entity1.CountryId).FirstOrDefault().CountryName;
strState = states.Where(s => s.StateId == entity1.StateId).FirstOrDefault().StateName;
strDistrict = District.Where(c => c.DistrictId == entity1.DistrictId).FirstOrDefault().DistrictName;
strCity = Cities.Where(c => c.CityId == entity1.CityId).FirstOrDefault().CityName;
}
// *********
StudentBAL balObject = new StudentBAL();
//IQueryable<Entities.Student> entites = balObject.FindBy(s => s.StudentId == studentId );
IQueryable <Entities.Student> entites = balObject.GetAll(SessionHelper.SchoolId).Where(c => c.StudentId == studentId);
if (entites != null && entites.Count() > 0)
{
Entities.Student entity = entites.FirstOrDefault();
DataRow dr = dt.NewRow();
dr["StudentId"] = entity.UStudentId;
dr["FirstName"] = entity.FirstName.Trim();
dr["MiddleName"] = entity.MiddleName.Trim();;
dr["LastName"] = entity.LastName.Trim();;
dr["MotherName"] = entity.MotherName.Trim();;
dr["ReligionName"] = entity.ReligionName.Trim();;
dr["CastName"] = entity.CastName.Trim();
dr["SubCast"] = ""; //TODO
dr["Nationality"] = entity.Nationality.Trim();
dr["DateOfBirth"] = entity.DateOfBirth; //Date
dr["PlaceOfBirth"] = entity.PlaceOfBirth;
if (entity.DateOfBirth != null)
{
dr["DateOfBirthInWord"] = DateToText(entity.DateOfBirth);
}
else
{
dr["DateOfBirthInWord"] = "";
}
dr["LastSchool"] = entity.LastSchoolAttended;
dr["DateOfAdmission"] = entity.DateOfAdmission; //Date
if (entity.DateOfAdmission != null)
{
dr["DateOfAdmission"] = entity.DateOfAdmission;//Date
}
dr["Progress"] = entity.Progress;
dr["Conduct"] = entity.Conduct;
if (entity.DateOfLeavingSchool != null)
{
dr["DateOfLeaveingSchool"] = entity.DateOfLeavingSchool;//Date
dr["DateOfLeaveingSchoolInWords"] = DateToText((System.DateTime)entity.DateOfLeavingSchool);
}
else
{
dr["DateOfLeaveingSchoolInWords"] = "";
}
dr["ClassInWhichStudingAndSinceWhen"] = entity.ClassInWhichStudingAndSinceWhen;
dr["Reason"] = entity.ReasonForLeavingSchool;
dr["Remark"] = entity.RemarkOnTC;
dr["RegisterNo"] = entity.RegisterId;
dr["TCPrinted"] = entity.TCPrinted;
if (!entity.TCPrinted)
{
long maxTCNo = balObject.GetMaxTCNo();
dr["TCNo"] = FormatedTCNo(Convert.ToString(maxTCNo + 1));
//if (isPrintExport)
// UpdateTCDetails(studentId);
}
else
{
dr["TCNo"] = FormatedTCNo(Convert.ToString(entity.TCNo));
}
if (isPrintExport)
{
UpdateTCDetails(studentId);
}
dr["AdharcardNo"] = entity.AdharcardNo;
dr["MotherTounge"] = entity.MotherTounge;
// ****
dr["Taluka"] = strCity;
dr["District"] = strDistrict;
dr["state"] = strState;
dr["Country"] = strCountry;
dt.Rows.Add(dr);
reportName = entity.RegisterId + "_" + entity.LastName.Trim() + "_" + entity.FirstName.Trim();
}
ds.Tables.Add(getSchoolDetails());
ds.Tables.Add(dt);
return(ds);
}
