public Object ViewRecord(Int64 OwnerID)
{
DAL.OwnerList owner = new OwnerList();
try
{
owner = DALOwner.ViewOwnerRecord(Convert.ToInt64(OwnerID));
}
catch (Exception ex)
{
throw;
}
return owner;
}
public Object GetRecord(String OwnerID)
{
DAL.OwnerList owner = new OwnerList();
try
{
owner = DALOwner.ViewOwnerAsClientRecord(OwnerID);
}
catch (Exception ex)
{
throw;
}
return owner;
}
public ActionResult AddRecord( String OwnerID, String PropID, String SiteID, String ClientID)
{
if (Session["Login"] != null)
{
LoginSession loginsession = (LoginSession)Session["Login"];
ViewBag.CompanyLogo = loginsession.CompanyLogo;
ViewBag.Layout1 = BAL.Common.LayoutType(loginsession.UserType);
String actionName = this.ControllerContext.RouteData.Values["action"].ToString();
String controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ViewBag.Menu = BAL.Common.GetActiveMenu(controllerName, actionName, BAL.Common.LayoutType(loginsession.UserType));
ViewBag.RoleName = loginsession.RoleName;
ConsumerMaster _Consumer = new ConsumerMaster();
DAL.OwnerList ownerobj = new DAL.OwnerList();
String DClientID = String.Empty;
String DSiteID = String.Empty;
String DPropID = String.Empty;
String DOwnerID = String.Empty;
String DConsID = String.Empty;
if ((ClientID != null)&&(DSiteID != null)&&(PropID != null) && (OwnerID != null))
{
DClientID = BAL.Security.URLDecrypt(ClientID);
_Consumer.ClientID = Convert.ToInt64(DClientID);
ViewBag.Client_ID = Convert.ToInt64(DClientID);
DSiteID = BAL.Security.URLDecrypt(SiteID);
_Consumer.SiteID = Convert.ToInt64(DSiteID);
ViewBag.Site_ID = Convert.ToInt64(DSiteID);
DPropID = BAL.Security.URLDecrypt(PropID);
_Consumer.PropertyID = Convert.ToInt64(DPropID);
ViewBag.Property_ID = Convert.ToInt64(DPropID);
DOwnerID = BAL.Security.URLDecrypt(OwnerID);
_Consumer.OwnerID = Convert.ToInt64(DOwnerID);
ViewBag.Owner_ID = Convert.ToInt64(DOwnerID);
ownerobj = BAL.OwnerModel.ViewOwner(DOwnerID);
if (ownerobj != null)
{
_Consumer.Property = ownerobj.PropertyNo;
_Consumer.Client = ownerobj.Client;
_Consumer.Site = ownerobj.Site;
_Consumer.Owner = ownerobj.ContactName;
}
}
return View(_Consumer);
}
else
{ return RedirectToAction("Index", "Home"); }
}
//public static IEnumerable<OwnerList> OwnerRecordList(String Field, String value)
//{
// try
// {
// using (var context = new SycousCon())
// {
// if (Field == "PropertyNo")
// {
// return (from O in context.Owners
// join P in context.Properties
// on O.PropertyID equals P.ID
// join S in context.SiteMasters
// on O.SiteID equals S.Id
// join C in context.ClientMasters
// on S.ClientID equals C.ClientID
// where (O.IsDeleted == 0 && P.IsDeleted == 0 && S.IsDeleted == 0 && C.DeleteStatus == 0 && P.PropertyNumber.Contains(value))
// orderby O.CreateDate descending, O.ModifyDate descending
// select new OwnerList()
// {
// OwnerID = SqlFunctions.StringConvert((Double)O.ID).Trim(),
// ContactName = ((O.FirstName.Trim() != "") ? O.FirstName.Trim() : "") + " " + ((O.LastName.Trim() == null) ? "" : O.LastName.Trim()),
// FirstName= O.FirstName,
// LastName=O.LastName,
// PropertyNo = P.PropertyNumber + " " + P.Address1 ,
// StartDate = O.StartDate,
// ClientID = SqlFunctions.StringConvert((Double)C.ClientID).Trim(),
// SiteID = SqlFunctions.StringConvert((Double)S.Id).Trim()
// }).ToList();
// }
// else if (Field == "Client")
// {
// return (from O in context.Owners
// join P in context.Properties
// on O.PropertyID equals P.ID
// join S in context.SiteMasters
// on O.SiteID equals S.Id
// join C in context.ClientMasters
// on S.ClientID equals C.ClientID
// where (O.IsDeleted == 0 && P.IsDeleted == 0 && S.IsDeleted == 0 && C.DeleteStatus == 0 && C.Name.Contains(value))
// orderby O.CreateDate descending, O.ModifyDate descending
// select new OwnerList()
// {
// OwnerID = SqlFunctions.StringConvert((Double)O.ID).Trim(),
// ContactName = ((O.FirstName.Trim() != "") ? O.FirstName.Trim() : "") + " " + ((O.LastName.Trim() == null) ? "" : O.LastName.Trim()),
// FirstName= O.FirstName,
// LastName=O.LastName,
// PropertyNo = P.PropertyNumber + " " + P.Address1,
// StartDate = O.StartDate,
// ClientID = SqlFunctions.StringConvert((Double)C.ClientID).Trim(),
// SiteID = SqlFunctions.StringConvert((Double)S.Id).Trim()
// }).ToList();
// }
// else if (Field == "Site")
// {
// return (from O in context.Owners
// join P in context.Properties
// on O.PropertyID equals P.ID
// join S in context.SiteMasters
// on O.SiteID equals S.Id
// join C in context.ClientMasters
// on S.ClientID equals C.ClientID
// where (O.IsDeleted == 0 && P.IsDeleted == 0 && S.IsDeleted == 0 && C.DeleteStatus == 0 && S.SiteName.Contains(value))
// orderby O.CreateDate descending, O.ModifyDate descending
// select new OwnerList()
// {
// OwnerID = SqlFunctions.StringConvert((Double)O.ID).Trim(),
// ContactName = ((O.FirstName.Trim() != "") ? O.FirstName.Trim() : "") + " " + ((O.LastName.Trim() == null) ? "" : O.LastName.Trim()),
// FirstName = O.FirstName,
// LastName = O.LastName,
// PropertyNo = P.PropertyNumber + " " + P.Address1,
// StartDate = O.StartDate,
// ClientID = SqlFunctions.StringConvert((Double)C.ClientID).Trim(),
// SiteID = SqlFunctions.StringConvert((Double)S.Id).Trim()
// }).ToList();
// }
// else if (Field == "Contact")
// {
// return (from O in context.Owners
// join P in context.Properties
// on O.PropertyID equals P.ID
// join S in context.SiteMasters
// on O.SiteID equals S.Id
// join C in context.ClientMasters
// on S.ClientID equals C.ClientID
// where (O.IsDeleted == 0 && P.IsDeleted == 0 && S.IsDeleted == 0 && C.DeleteStatus == 0 && O.ContactName.Contains(value))
// orderby O.CreateDate descending, O.ModifyDate descending
// select new OwnerList()
// {
// OwnerID = SqlFunctions.StringConvert((Double)O.ID).Trim(),
// ContactName = ((O.FirstName.Trim() != "") ? O.FirstName.Trim() : "") + " " + ((O.LastName.Trim() == null) ? "" : O.LastName.Trim()),
// FirstName = O.FirstName,
// LastName = O.LastName,
// PropertyNo = P.PropertyNumber + " " + P.Address1,
// StartDate = O.StartDate,
// ClientID = SqlFunctions.StringConvert((Double)C.ClientID).Trim(),
// SiteID = SqlFunctions.StringConvert((Double)S.Id).Trim()
// }).ToList();
// }
// else
// {
// return (from O in context.Owners
// join P in context.Properties
// on O.PropertyID equals P.ID
// join S in context.SiteMasters
// on O.SiteID equals S.Id
// join C in context.ClientMasters
// on S.ClientID equals C.ClientID
// where (O.IsDeleted == 0 && P.IsDeleted == 0 && S.IsDeleted == 0 && C.DeleteStatus == 0 && (O.ContactName.Contains(value) || S.SiteName.Contains(value) || C.Name.Contains(value) || P.PropertyNumber.Contains(value)))
// orderby O.CreateDate descending, O.ModifyDate descending
// select new OwnerList()
// {
// OwnerID = SqlFunctions.StringConvert((Double)O.ID).Trim(),
// ContactName = ((O.FirstName.Trim() != "") ? O.FirstName.Trim() : "") + " " + ((O.LastName.Trim() == null) ? "" : O.LastName.Trim()),
// FirstName = O.FirstName,
// LastName = O.LastName,
// PropertyNo = P.PropertyNumber + " " + P.Address1,
// StartDate = O.StartDate,
// ClientID = SqlFunctions.StringConvert((Double)C.ClientID).Trim(),
// SiteID = SqlFunctions.StringConvert((Double)S.Id).Trim()
// }).ToList();
// }
// }
// }
// catch (Exception ex)
// {
// throw;
// }
//}//OwnerRecordList
public static OwnerList ViewOwnerRecord(Int64 ownerID)
{
OwnerList owner = new OwnerList();
using (var context = new SycousCon())
{
try
{
owner = (from O in context.Owners
join P in context.Properties
on O.PropertyID equals P.ID
join S in context.SiteMasters
on O.SiteID equals S.Id
join C in context.ClientMasters
on S.ClientID equals C.ClientID
where (O.IsDeleted == 0 && P.IsDeleted == 0 && S.IsDeleted == 0 && C.DeleteStatus == 0 && O.ID == ownerID)
orderby O.CreateDate descending, O.ModifyDate descending
select new OwnerList()
{
OwnerID = SqlFunctions.StringConvert((Double)O.ID).Trim(),
ContactName = ((O.FirstName.Trim() != "") ? O.FirstName.Trim() : "") + " " + ((O.LastName.Trim() == null) ? "" : O.LastName.Trim()),
PropertyNo = P.PropertyNumber + "" + P.Address1 ,
StartDate = O.StartDate,
Email = O.Email,
IsMailService = O.MailService,
BankName = O.BankName,
BankSortCode = O.BankSortCode,
BankAccountNo = O.BankAccountNo,
Address1 = O.Address1,
Address2 = O.Address2,
City= O.City,
County = O.County,
Telephone = O.Telephone,
Mobile = O.Mobile,
Agent = O.Agent,
Client= C.Name,
Site = S.SiteName,
FirstName= O.FirstName,
LastName=O.LastName,
Notes = O.Notes,
AgentTelephone = O.AgentTelephone,
AgentEmail= O.AgentEmail,
ClientRef = O.ClientRefNo,
OwnerType ="1"
}).FirstOrDefault();
return owner;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public static OwnerList ViewOwnerAsClientRecord(String OwnerID)
{
OwnerList Owner = new OwnerList();
using (var context = new SycousCon())
{
try
{
var parmode = new SqlParameter
{
ParameterName = "mode",
Value = "3",
Direction = ParameterDirection.Input
};
var pOwnerID = new SqlParameter
{
ParameterName = "OwnerID",
Value = OwnerID,
Direction = ParameterDirection.Input
};
Owner = context.ExecuteStoreQuery<OwnerList>("exec [SYCOUS].[PropertyOwnerList] @mode,@OwnerID", parmode, pOwnerID).FirstOrDefault();
return Owner;
}
catch (Exception ex)
{
context.Dispose();
throw;
}
}
}
public ActionResult OView(String OwnerID , String Type)
{
if (Session["Login"] != null)
{
LoginSession loginsession = (LoginSession)Session["Login"];
ViewBag.CompanyLogo = loginsession.CompanyLogo;
ViewBag.Layout1 = BAL.Common.LayoutType(loginsession.UserType);
String actionName = this.ControllerContext.RouteData.Values["action"].ToString();
String controllerName = this.ControllerContext.RouteData.Values["controller"].ToString();
ViewBag.Menu = BAL.Common.GetActiveMenu(controllerName, actionName, BAL.Common.LayoutType(loginsession.UserType));
if ((OwnerID != null) && (Type != null))
{
String Dec_OwnerID = BAL.Security.URLDecrypt(OwnerID);
String DOwnerType = BAL.Security.URLDecrypt(Type);
DAL.OwnerList owner = new DAL.OwnerList();
if ((Dec_OwnerID != "0") && (Dec_OwnerID != null))
{
try
{
if (DOwnerType == "1")
{
owner = BAL.OwnerModel.ViewOwner(Dec_OwnerID);
}
if (DOwnerType == "2")
{
owner = BAL.OwnerModel.ViewOwnerAsClientRecord(Dec_OwnerID);
}
}
catch (Exception ex)
{
return Content("Execption:" + ex.Message);
}
}
return View(owner);
}
else
{ return RedirectToAction("Index", "Notify"); }
}
else
{ return RedirectToAction("Index", "Home"); }
}
