public ActionResult PersonList()
{
DAL.DataAccess.CallingDAL.CommonDA CDA = new DAL.DataAccess.CallingDAL.CommonDA();
DataTable DTPersons = new DataTable();
var plist = new List <PersonListModel>();
if (GlobalInfo.RoleID == 9)
{
DTPersons = CDA.GetPersonsList(0, GlobalInfo.OID);
for (int i = 0; i < DTPersons.Rows.Count; i++)
{
var p = new PersonListModel();
p.FirstName = DTPersons.Rows[i]["FirstName"].ToString();
p.MiddleName = DTPersons.Rows[i]["MiddleName"].ToString();
p.LastName = DTPersons.Rows[i]["LastName"].ToString();
p.DateofBirth = DTPersons.Rows[i]["DOB"].ToString();
p.PersonID = Convert.ToInt32(DTPersons.Rows[i]["PersonID"]);
p.Telephone = DTPersons.Rows[i]["PhonePersonal"].ToString();
p.Mobile = DTPersons.Rows[i]["MobilePersonal"].ToString();
p.EmailAddress = DTPersons.Rows[i]["EmailPersonal"].ToString();
p.IsMember = Convert.ToBoolean(DTPersons.Rows[i]["IsMember"]);
plist.Add(p);
}
}
ViewBag.PersonList = plist;
return(View());
}
public string Get()
{
DAL.DataAccess.CallingDAL.CommonDA CDA = new DAL.DataAccess.CallingDAL.CommonDA();
DataTable DTPersons = new DataTable();
string data = "";
DTPersons = CDA.GetPersonsList(0, GlobalInfo.OID);
for (int i = 0; i < DTPersons.Rows.Count; i++)
{
var p = new PersonListModel();
p.FirstName = DTPersons.Rows[i]["FirstName"].ToString();
p.MiddleName = DTPersons.Rows[i]["MiddleName"].ToString();
p.LastName = DTPersons.Rows[i]["LastName"].ToString();
p.DateofBirth = DTPersons.Rows[i]["DOB"].ToString();
p.PersonID = Convert.ToInt32(DTPersons.Rows[i]["PersonID"]);
p.Telephone = DTPersons.Rows[i]["PhonePersonal"].ToString();
p.Mobile = DTPersons.Rows[i]["MobilePersonal"].ToString();
p.EmailAddress = DTPersons.Rows[i]["EmailPersonal"].ToString();
p.IsMember = Convert.ToBoolean(DTPersons.Rows[i]["IsMember"]);
data += p.FirstName + "," + p.LastName + "," + p.PersonID + "," + p.Telephone;
}
return(data);
}
