internal List<VisitorsModel> HomeOwnerVisitors(HomeOwnersModel homeOwner)
{
AddParameter("@homeownerid",homeOwner.HomeOwnerID);
DataTable Dt_HomeOwnerVisitorsList = this.GetDataTable("usp_GetHomeOwnerVisitorsList");
visitorsList = new List<VisitorsModel>();
if (Dt_HomeOwnerVisitorsList.Rows.Count > 0)
{
foreach (DataRow dr in Dt_HomeOwnerVisitorsList.Rows)
{
visitorObj = new VisitorsModel();
visitorObj.VisitorID = Convert.ToInt64(dr["VisitorID"].ToString());
visitorObj.VisitorName = dr["VisitorName"].ToString();
visitorObj.VisitorTypeID = dr["VisitorTypeID"].ToString();
visitorObj.VisitorType = dr["VisitorType"].ToString();
visitorObj.VisitingDate = dr["VisitingDate"].ToString();
visitorObj.MobileNo = dr["MobileNo"].ToString();
visitorObj.EmailID = dr["EmailID"].ToString();
visitorObj.VisitingTo = dr["VisitingTo"].ToString();
visitorObj.Comments = dr["Comments"].ToString();
//visitorObj.Status = dr["Status"].ToString();
visitorObj.CreatedOn = Convert.ToDateTime(dr["CreatedOn"].ToString());
visitorObj.CreatedUserID = Convert.ToInt64(dr["CreatedUserID"].ToString());
visitorObj.CreatedRoleID = Convert.ToByte(dr["CreatedRoleID"].ToString());
if (!String.IsNullOrEmpty(dr["ModifiedOn"].ToString()))
{
visitorObj.ModifiedOn = Convert.ToDateTime(dr["ModifiedOn"].ToString());
visitorObj.ModifiedUserID = Convert.ToInt64(dr["ModifiedUserID"].ToString());
visitorObj.ModifiedRoleID = Convert.ToByte(dr["ModifiedRoleID"].ToString());
}
visitorsList.Add(visitorObj);
}
}
return visitorsList;
}
internal Object DeleteVisitor(VisitorsModel visitor)
{
AddParameter("@visitorid", visitor.VisitorID);
AddParameter("@modifieduserid", visitor.ModifiedUserID);
AddParameter("@modifiedroleid", visitor.ModifiedRoleID);
AddParameter("@modifiedon", visitor.ModifiedOn);
return ExecuteScalar("usp_DeleteVisitor");
}
internal object AddVisitor(VisitorsModel visitor)
{
AddParameter("@communityid", visitor.CommunityID);
AddParameter("@visitorname", visitor.VisitorName);
AddParameter("@visitortypeid", visitor.VisitorType);
AddParameter("@visitingdate", visitor.VisitingDate);
AddParameter("@mobileno", visitor.MobileNo);
AddParameter("@emailid", visitor.EmailID);
AddParameter("@visitingto", visitor.VisitingTo);
AddParameter("@comments", visitor.Comments);
AddParameter("@createduserid", visitor.CreatedUserID);
AddParameter("@createdroleid", visitor.CreatedRoleID);
AddParameter("@createdon", visitor.CreatedOn);
return this.ExecuteScalar("usp_AddVisitor");
}
internal object UpdateVisitor(VisitorsModel Visitor)
{
AddParameter("@visitorid", Visitor.VisitorID);
AddParameter("@visitorname", Visitor.VisitorName);
AddParameter("@visitortypeid", Visitor.VisitorType);
AddParameter("@visitingdate", Visitor.VisitingDate);
AddParameter("@mobileno", Visitor.MobileNo);
AddParameter("@emailid", Visitor.EmailID);
AddParameter("@visitingto", Visitor.VisitingTo);
AddParameter("@comments", Visitor.Comments);
//AddParameter("@status", Visitor.Status);
AddParameter("@modifieduserid", Visitor.ModifiedUserID);
AddParameter("@modifiedroleid", Visitor.ModifiedRoleID);
AddParameter("@modifiedon", Visitor.ModifiedOn);
return this.ExecuteScalar("usp_UpdateVisitor");
}
internal VisitorsModel EditVisitor(VisitorsModel visitor)
{
return this.VisitorDetails(visitor);
}
//internal List<VisitorsModel> MyVisitorsList(VisitorsModel visitor)
//{
// AddParameter("@createduserid", visitor.CreatedUserID);
// DataTable Dt_MyVisitorsList = this.GetDataTable("usp_GetMyVisitorsList");
// visitorsList = new List<VisitorsModel>();
// if (Dt_MyVisitorsList.Rows.Count > 0)
// {
// for (int i = 0; i < Dt_MyVisitorsList.Rows.Count; i++)
// {
// visitorObj = new VisitorsModel();
// visitorObj.VisitorID = Convert.ToInt64(Dt_MyVisitorsList.Rows[i]["VisitorID"].ToString());
// visitorObj.VisitorName = Dt_MyVisitorsList.Rows[i]["VisitorName"].ToString();
// visitorObj.VisitorTypeID = Dt_MyVisitorsList.Rows[i]["VisitorTypeID"].ToString();
// visitorObj.VisitorType = Dt_MyVisitorsList.Rows[i]["VisitorType"].ToString();
// visitorObj.VisitingDate = Dt_MyVisitorsList.Rows[i]["VisitingDate"].ToString();
// visitorObj.MobileNo = Dt_MyVisitorsList.Rows[i]["MobileNo"].ToString();
// visitorObj.EmailID = Dt_MyVisitorsList.Rows[i]["EmailID"].ToString();
// visitorObj.VisitingTo = Dt_MyVisitorsList.Rows[i]["VisitingTo"].ToString();
// visitorObj.Comments = Dt_MyVisitorsList.Rows[i]["Comments"].ToString();
// //visitorObj.Status = Dt_MyVisitorsList.Rows[i]["Status"].ToString();
// visitorObj.CreatedOn = Dt_MyVisitorsList.Rows[i]["CreatedOn"].ToString();
// visitorObj.CreatedUserID = Dt_MyVisitorsList.Rows[i]["CreatedBy"].ToString();
// visitorObj.ModifiedOn = Dt_MyVisitorsList.Rows[i]["ModifiedOn"].ToString();
// visitorObj.ModifiedUserID = Dt_MyVisitorsList.Rows[i]["ModifiedBy"].ToString();
// visitorsList.Add(visitorObj);
// }
// }
// return visitorsList;
//}
internal VisitorsModel VisitorDetails(VisitorsModel visitor)
{
AddParameter("@visitorid", visitor.VisitorID);
DataTable Dt_VisitorDetails = this.GetDataTable("usp_GetVisitorDetails");
if (Dt_VisitorDetails.Rows.Count > 0)
{
foreach (DataRow dr in Dt_VisitorDetails.Rows)
{
visitorDetails = new VisitorsModel();
visitorDetails.VisitorID = Convert.ToInt64(dr["VisitorID"].ToString());
visitorDetails.CommunityID = Convert.ToInt16(dr["CommunityID"].ToString());
visitorDetails.VisitorName = dr["VisitorName"].ToString();
visitorDetails.VisitorTypeID = dr["VisitorTypeID"].ToString();
//visitorDetails.VisitorType = dr["VisitorType"].ToString();
visitorDetails.VisitingDate = dr["VisitingDate"].ToString();
visitorDetails.MobileNo = dr["MobileNo"].ToString();
visitorDetails.EmailID = dr["EmailID"].ToString();
visitorDetails.VisitingTo = dr["VisitingTo"].ToString();
visitorDetails.Comments = dr["Comments"].ToString();
//visitorDetails.Status = dr["Status"].ToString();
visitorDetails.CreatedOn = Convert.ToDateTime(dr["CreatedOn"].ToString());
visitorDetails.CreatedUserID = Convert.ToInt64(dr["CreatedUserID"].ToString());
visitorDetails.CreatedRoleID = Convert.ToByte(dr["CreatedRoleID"].ToString());
if (!String.IsNullOrEmpty(dr["ModifiedOn"].ToString()))
{
visitorDetails.ModifiedOn = Convert.ToDateTime(dr["ModifiedOn"].ToString());
visitorDetails.ModifiedUserID = Convert.ToInt64(dr["ModifiedUserID"].ToString());
visitorDetails.ModifiedRoleID = Convert.ToByte(dr["ModifiedRoleID"].ToString());
}
visitorDetails.Status = Convert.ToChar(dr["Status"].ToString());
}
}
return visitorDetails;
}
public ActionResult NewVisitor()
{
visitor = new VisitorsModel();
visitor.CommunityID = myCommunityID;
return PartialView("Partials/Visitors/NewVisitor");
}
public ActionResult NewVisitor(VisitorsModel visitor)
{
if (this.ModelState.IsValid)
{
visitorsDAL.AddVisitor(visitor);
return View();
}
else
return null;
}
public ActionResult DeleteVisitor(String visitorid)
{
visitor = new VisitorsModel();
visitor.VisitorID = Convert.ToInt64(visitorid);
visitorsDAL.DeleteVisitor(visitor);
return RedirectToAction("VisitorsList");
}
public ActionResult EditVisitor(String visitorid)
{
visitor = new VisitorsModel();
visitor.CommunityID = myCommunityID;
visitor.VisitorID = Convert.ToInt64(visitorid.ToString());
return PartialView("Partials/Visitors/EditVisitor", visitorsDAL.VisitorDetails(visitor));
}
public ActionResult VisitorsListTable()
{
visitor = new VisitorsModel();
visitor.CommunityID = myCommunityID;
return PartialView("Partials/Visitors/VisitorsListTable", visitorsDAL.VisitorsList(visitor));
}
public ActionResult VisitorDetails(String visitorid)
{
if (VisitorIDSanctityCheck(visitorid))
{
visitor = new VisitorsModel();
visitor.CommunityID = myCommunityID;
visitor.VisitorID = outVisitorID;
return PartialView("Partials/Visitors/VisitorDetails", visitorsDAL.VisitorDetails(visitor));
}
else
return AjaxParamError("Visitor");
}
public void UpdateVisitor(FormCollection fc, VisitorsModel visitor)
{
visitorsDAL.UpdateVisitor(visitor);
}
public ActionResult EditVisitor(String visitorid)
{
visitor = new VisitorsModel();
visitor.VisitorID = Convert.ToInt64(visitorid.ToString());
ViewBag.VisitorDetails = visitorsDAL.VisitorDetails(visitor);
return View();
}
public ActionResult VisitorDetails(String visitorid)
{
if (VisitorIDSanctityCheck(visitorid))
{
visitor = new VisitorsModel();
visitor.VisitorID = Convert.ToInt64(visitorid.ToString());
ViewBag.VisitorDetails = visitorsDAL.VisitorDetails(visitor);
return View();
}
else
return AjaxParamError("Visitor");
}
