public static void AddDataOnLinkDetails(LinkDetailEntity item)
{
try
{
using (FacilitiesEntities _dbContext = new FacilitiesEntities())
{
var data = _dbContext.CGSLinkDetails.Where(x => x.CGSLinkHeader == item.CGSLinkHeader).ToList();
if (data != null)
{
foreach (var ss in item.Value)
{
var dd = data.FirstOrDefault(r => r.ColumnHeader == ss.Key);
LinkDetail LD = new LinkDetail();
LD.LinkDetailId = Guid.NewGuid();
LD.CGSLinkHeader = item.CGSLinkHeader;
LD.CGSLinkDetails = dd.CGSLinkDetailId;
LD.LinkHeader = item.LinkHeader;
LD.Value = ss.value;
_dbContext.LinkDetails.Add(LD);
_dbContext.SaveChanges();
}
}
}
}
catch (Exception ex)
{
throw (ex);
}
}
public static void AddDataInClientUser(ClientUser item)
{
ClientUser CU = new ClientUser();
try
{
using (FacilitiesEntities _dbContext = new FacilitiesEntities())
{
var GetClientRoleId = _dbContext.Roles.Where(a => a.RoleName == "Client User" && a.ActiveFlag == "Y").FirstOrDefault();
if (GetClientRoleId != null)
{
CU.ClientUserId = Guid.NewGuid();
CU.Client = item.Client;
CU.Role = GetClientRoleId.RoleId;
CU.User = item.User;
CU.ActiveFlag = "Y";
_dbContext.ClientUsers.Add(CU);
_dbContext.SaveChanges();
}
}
}
catch (Exception ex)
{
throw (ex);
}
}
public List <ValueEntity> GetLinkDetailData(string RandamString)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
var data = db.LinkHeaders.Where(x => x.RandomString == RandamString).FirstOrDefault();
List <ValueEntity> obj = new List <ValueEntity>();
foreach (var ss in data.CGSLinkHeader1.CGSLinkDetails)
{
foreach (var aa in data.LinkDetails)
{
if (ss.CGSLinkDetailId == aa.CGSLinkDetails)
{
ValueEntity obj1 = new ValueEntity();
obj1.Key = ss.ColumnHeader;
obj1.value = aa.Value;
obj1.LinkHeaderId = data.LinkHeaderId;
obj.Add(obj1);
}
}
}
return(obj);
}
catch (Exception ex)
{
throw (ex);
}
}
}
public static LinkHeader AddDataOnLinkHeader <T>(LinkHeader item)
{
LinkHeader LH = new LinkHeader();
try
{
using (FacilitiesEntities _dbContext = new FacilitiesEntities())
{
var data = _dbContext.CGSLinkHeaders.Where(x => x.Action == item.Action).FirstOrDefault();
if (data != null)
{
LH.LinkHeaderId = Guid.NewGuid();
LH.CGSLinkHeader = data.CGSLinkHeaderId;
LH.Action = data.Action;
LH.RandomString = item.RandomString;
LH.BeginDate = DateTime.Now;
var TimeFrame = data.Timeframe;
var endDate = DateTime.Now;
endDate = endDate.AddDays(TimeFrame);
LH.EndDate = endDate;
_dbContext.LinkHeaders.Add(LH);
_dbContext.SaveChanges();
}
}
return(LH);
}
catch (Exception ex)
{
return(null);
}
}
public Guid AddNewClientRequest(CreateNewUsersEntity item)
{
Guid UserID = Guid.Empty;
using (FacilitiesEntities dB = new FacilitiesEntities())
{
try
{
if (item.UserEntity.UserId == Guid.Empty)
{
var U = VM_User.AddDataInUser <User>(item.UserEntity);
var UserId1 = dB.ClientUsers.Where(x => x.User == U.UserId).FirstOrDefault();
if (U != null && UserId1 == null)
{
item.ClientUserEntity.User = U.UserId;
VM_ClientUsers.AddDataInClientUser(item.ClientUserEntity);
UserID = U.UserId;
}
}
else
{
item.UserEntity.ActiveFlag = item.ClientUserEntity.ActiveFlag;
VM_ClientUsers.UpdateDataInClientUser(item.ClientUserEntity);
var U = VM_User.UpdateDataInUser <User>(item.UserEntity);
}
}
catch (Exception ex)
{
throw (ex);
}
}
return(UserID);
}
private List <EmailDataForClientDetails> GetEmailDataforClientDetails(Guid LoggedInUserId)
{
try
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
var EmailDataforClients = (from cu in db.ClientUsers
join cl in db.Clients on cu.Client equals cl.ClientId
join u in db.Users on cu.User equals u.UserId
where u.UserId == LoggedInUserId
select new
{
FirstName = u.FirstName,
LastName = u.LastName,
ClientName = cl.ClientName
}).ToList().Select(W => new EmailDataForClientDetails()
{
FirstName = W.FirstName,
LastName = W.LastName,
ClientName = W.ClientName
}).ToList();
return(EmailDataforClients);
}
}
catch
{
return(null);
}
}
//static readonly FacilitiesEntities _dbContext;
public static User AddDataInUser <T>(User item)
{
User U = new User();
try
{
using (FacilitiesEntities _dbContext = new FacilitiesEntities())
{
var checkUser = _dbContext.Users.Where(p => p.Email.ToLower().Trim() == item.Email.ToLower().Trim()).FirstOrDefault();
if (checkUser == null)
{
U.UserId = Guid.NewGuid();
U.FirstName = item.FirstName;
U.LastName = item.LastName;
U.Email = item.Email;
U.ActiveFlag = "R";
_dbContext.Users.Add(U);
}
else
{
U.UserId = checkUser.UserId;
U.ActiveFlag = checkUser.ActiveFlag;
}
_dbContext.SaveChanges();
return(U);
}
}
catch (Exception ex)
{
throw (ex);
}
}
public bool DeleteAssociatedCustomerLocationAndVendor(Guid VenderId, int AssociatedVenderLocationCount)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
if (AssociatedVenderLocationCount > 0)
{
var PMVendorCustomerLocations = db.PMVendorCustomerLocations.Where(x => x.PMVendor == VenderId);
db.PMVendorCustomerLocations.RemoveRange(PMVendorCustomerLocations);
var DeleteDataFromPmVendor = db.PMVendors.Where(a => a.PMVendorId == VenderId);
db.PMVendors.RemoveRange(DeleteDataFromPmVendor);
}
else
{
var DeleteDataFromPmVendor = db.PMVendors.Where(a => a.PMVendorId == VenderId);
db.PMVendors.RemoveRange(DeleteDataFromPmVendor);
}
db.SaveChanges();
return(true);
}
catch (Exception ex)
{
throw (ex);
}
}
}
public IEnumerable <InsuranceType> GetInsuranceType(Guid ClientID)
{
try
{
using (FacilitiesEntities DB = new FacilitiesEntities())
{
var InsuranceTypeList = (from C in DB.ClientInsuranceTypes
where C.Client == ClientID && C.ActiveFlag == "Y"
select new
{
ClientInsuranceTypeId = C.ClientInsuranceTypeId,
Description = C.Description
}).ToList().Select(x => new InsuranceType()
{
ClientInsuranceTypeId = x.ClientInsuranceTypeId,
Description = x.Description
}).ToList();
return(InsuranceTypeList);
}
}
catch (Exception ex)
{
return(null);
}
}
private List <EmailDataForQuoteInvoice> GetEmailData(Guid ServiceRequestInvoiceHeaderId)
{
try
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
var EmailData = (from cl in db.Clients
join cc in db.ClientCustomers on cl.ClientId equals cc.Client
join cs in db.Customers on cc.Customer equals cs.CustomerId
join sr in db.ServiceRequests on cs.CustomerId equals sr.Customer
join sri in db.ServiceRequestInvoiceHeaders on sr.ServiceRequestId equals sri.ServiceRequest
join us in db.Users on sri.User equals us.UserId
where sri.ServiceRequestInvoiceHeaderId == ServiceRequestInvoiceHeaderId
select new
{
FirstName = us.FirstName,
LastName = us.LastName,
CustomerName = cs.CustomerName,
ClientName = cl.ClientName
}).ToList().Select(W => new EmailDataForQuoteInvoice()
{
FirstName = W.FirstName,
LastName = W.LastName,
CustomerName = W.CustomerName,
ClientName = W.ClientName
}).ToList();
return(EmailData);
}
}
catch
{
return(null);
}
}
public IEnumerable <ClientInsuranceDetails> GetInsuranceGridDetails(Guid ClientVendorId)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
var GetInsuranceDetails = (from CV in db.ClientVendorInsurances
join IT in db.ClientInsuranceTypes on CV.InsuranceType equals IT.ClientInsuranceTypeId
where CV.ClientVendor == ClientVendorId
select new
{
ClientVendorInsuranceId = CV.ClientVendorInsuranceId,
InsuranceCompanyName = CV.InsuranceCompanyName,
CoverageBeginDate = CV.CoverageBeginDate,
CoverageEndDate = CV.CoverageEndDate,
_InsuranceTypeID = CV.InsuranceType,
Description = IT.Description
}).ToList().Select(W => new ClientInsuranceDetails()
{
ClientVendorInsuranceId = W.ClientVendorInsuranceId,
InsuranceCompName = W.InsuranceCompanyName,
InsuranceBeginDate = W.CoverageBeginDate.ToString(),
InsuranceEndDate = W.CoverageEndDate.ToString(),
InsuranceType = W.Description,
InsuranceTypeID = W._InsuranceTypeID
}).ToList();
return(GetInsuranceDetails);
}
}
public IEnumerable <ClientInsuranceDetails> GetInsurancedetails(Guid ClientVendorId)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
var GetInsuranceDetails = (from CV in db.ClientVendorInsurances
where CV.ClientVendorInsuranceId == ClientVendorId
select new
{
ClientVendorInsuranceId = CV.ClientVendorInsuranceId,
InsuranceCompanyName = CV.InsuranceCompanyName,
CoverageBeginDate = CV.CoverageBeginDate,
CoverageEndDate = CV.CoverageEndDate,
InsuranceDocument = CV.InsuranceDocument,
FileType = CV.FileType,
FileName = CV.FileName
}).ToList().Select(W => new ClientInsuranceDetails()
{
ClientVendorInsuranceId = W.ClientVendorInsuranceId,
InsuranceCompName = W.InsuranceCompanyName,
InsuranceBeginDate = W.CoverageBeginDate.ToString(),
InsuranceEndDate = W.CoverageEndDate.ToString(),
InsuranceDocument = W.InsuranceDocument,
InsuranceDocumentType = db.CGSFileTypes.Where(a => a.CGSFileTypesId == W.FileType).Select(a => a.Decription).FirstOrDefault(),
InsuranceDocumentName = W.FileName
}).ToList();
return(GetInsuranceDetails);
}
}
public Guid AddNewCustomerRequest(CreateNewUsersEntity item)
{
Guid UserID = Guid.Empty;
using (FacilitiesEntities dB = new FacilitiesEntities())
{
try
{
// Add data Customer Name In Customer Table
Customer C = new Customer();
if (item.UserEntity.UserId == Guid.Empty)
{
if (!IsCustomerExists(item.CustomerEntity.CustomerName))
{
// Add data User In User Table
var U = VM_User.AddDataInUser <User>(item.UserEntity);
//var UserId1 = dB.CustomerUsers.Where(x => x.User == U.UserId).FirstOrDefault();
if (U != null)
{
C.CustomerId = Guid.NewGuid();
C.CustomerName = item.CustomerEntity.CustomerName;
C.ActiveFlag = "Y";
dB.Customers.Add(C);
//Add data in clientcustomer Table
ClientCustomer CC = new ClientCustomer();
CC.ClientCustomerId = Guid.NewGuid();
CC.Client = item.ClientCustomerEntity.Client;
CC.Customer = C.CustomerId;
CC.ActiveFlag = "Y";
dB.ClientCustomers.Add(CC);
dB.SaveChanges();
item.CustomerUserEntity.User = U.UserId;
item.CustomerUserEntity.Customer = C.CustomerId;
VM_CustomerUsers.AddDataInCustomerUsers(item.CustomerUserEntity);
UserID = U.UserId;
}
}
}
else
{
var CUS = dB.Customers.Where(a => a.CustomerId == item.CustomerEntity.CustomerId).FirstOrDefault();
if (CUS != null)
{
var user = VM_User.UpdateDataInUser <User>(item.UserEntity);
item.CustomerUserEntity.ActiveFlag = item.UserEntity.ActiveFlag;
VM_CustomerUsers.UpdateDataInCustomerUsers(item.CustomerUserEntity);
CUS.CustomerName = item.CustomerEntity.CustomerName;
dB.SaveChanges();
}
}
}
catch (Exception ex)
{
throw (ex);
}
}
return(UserID);
}
public List <PMVendorsEntity> GetAssiocateVendor(Guid PMHeaderId)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
var VendorList = (from PV in db.PMVendors
join v in db.Vendors on PV.Vendor equals v.VendorId
where PV.PMHeader == PMHeaderId
orderby v.VendorName descending
select new
{
_PMVendorId = PV.PMVendorId,
_VendorName = v.VendorName,
_WONTE = PV.WONTE,
_Description = PV.Description
}).ToList().Select(x => new PMVendorsEntity()
{
PMVendorId = x._PMVendorId,
Vendor = x._VendorName,
WONTE = x._WONTE,
Description = x._Description
}).ToList();
return(VendorList);
}
catch (Exception ex)
{
throw (ex);
}
}
}
private List <EmailData> GetEmailData(Guid WorkOrderId)
{
try
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
var EmailData = (from wo in db.WorkOrders
join v in db.Vendors on wo.Vendor equals v.VendorId
join u in db.Users on wo.CreatedByUser equals u.UserId
join sr in db.ServiceRequests on wo.ServiceRequest equals sr.ServiceRequestId
join c in db.Clients on sr.Client equals c.ClientId
where wo.WorkOrderId == WorkOrderId
select new
{
WorkOrderId = wo.WorkOrderId,
VendorName = v.VendorName,
FirstName = u.FirstName,
LastName = u.LastName,
ClientName = c.ClientName
}).ToList().Select(W => new EmailData()
{
WorkOrderId = W.WorkOrderId,
VendorName = W.VendorName,
FirstName = W.FirstName,
LastName = W.LastName,
ClientName = W.ClientName
}).ToList();
return(EmailData);
}
}
catch
{
return(null);
}
}
public DataTable GetWOEditRecord(Guid clientPMHeaderID)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
List <PMWorkOrderCreationDate> WOEditRecord = (from pm in db.PMWorkOrderCreationDates
where pm.ClientPMHeader == clientPMHeaderID
select pm).OrderBy(x => x.WorkOrderCreationDate).ToList();
DataTable dt = new DataTable();
dt.Columns.Add("WorkOrderDate", typeof(string));
dt.Columns.Add("ArriveDateAndTime", typeof(string));
dt.Columns.Add("FinishDateAndTime", typeof(string));
foreach (PMWorkOrderCreationDate pMWorkOrder in WOEditRecord)
{
DataRow dr = dt.NewRow();
dr["WorkOrderDate"] = Convert.ToDateTime(pMWorkOrder.WorkOrderCreationDate).ToString("MM-dd-yyyy");
dr["ArriveDateAndTime"] = Convert.ToDateTime(pMWorkOrder.WorkOrderArriveDate).ToString("MM-dd-yyyy");
dr["FinishDateAndTime"] = Convert.ToDateTime(pMWorkOrder.WorkOrderFinishDate).ToString("MM-dd-yyyy");
dt.Rows.Add(dr);
}
return(dt);
}
}
public DataTable SaveDataOnPmHeader(PMHeaderEntity item)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
ClientPMHeader CH = new ClientPMHeader();
#region ADD/Update the PM header entries
if (item.ClientPMHeaderId != Guid.Empty)
{
CH = db.ClientPMHeaders.Where(a => a.ClientPMHeaderId == item.ClientPMHeaderId).FirstOrDefault();
}
else
{
CH.ClientPMHeaderId = Guid.NewGuid();
}
CH.Client = item.Client;
CH.Customer = item.Customer;
CH.ProblemClass = item.ProblemClass;
CH.ProblemCode = item.ProblemCode;
CH.RequestPriority = item.RequestPriority;
CH.ServiceRequestType = item.ServiceRequestType;
CH.CustomerReference = item.CustomerReference;
CH.IssueDescription = item.IssueDescription;
CH.Frequency = item.Frequency;
CH.BeginDate = item.BeginDate;
CH.EndDate = item.EndDate;
CH.ArriveDateAndTime = item.ArriveDateAndTime;
CH.FinishDateAndTime = item.FinishDateAndTime;
CH.WOInAdvance = item.WOInAdvance;
CH.CreatedByUser = item.UserId;
CH.ActiveFlag = "N";
if (item.ClientPMHeaderId == Guid.Empty)
{
db.ClientPMHeaders.Add(CH);
}
db.SaveChanges();
#endregion
#region CALCULATE and insert the schedular entries and return
DataTable dt = GetWOConfirmationDate(CH.ClientPMHeaderId);
DataView view = dt.DefaultView;
view.Sort = "WorkOrderCreationDate ASC";
DataTable sortedDate = view.ToTable();
#endregion
return(dt);
}
catch (Exception ex)
{
throw (ex);
}
}
}
public Guid CreateVendorFromWO(VendorEntities vendor)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
UOWVendor vendorObj = new UOWRepository.UOWVendor();
try
{
var newVendor = new Vendor();
if (vendor.Email != null && (!vendorObj.IsVendorExists(vendor.Email)))
{
newVendor.VendorId = Guid.NewGuid();
newVendor.VendorName = vendor.VendorName;
newVendor.Address01 = vendor.Address01 != null ? vendor.Address01 : " ";
newVendor.Address02 = vendor.Address02 != null ? vendor.Address02 : " ";
newVendor.City = vendor.City != null ? vendor.City : " ";
newVendor.State = vendor.State != null ? vendor.State : " ";
newVendor.Zip01 = vendor.Zip01 != null ? vendor.Zip01 : " ";
newVendor.Zip02 = vendor.Zip02 != null ? vendor.Zip02 : " ";
newVendor.Email = vendor.Email != null ? vendor.Email : " ";
newVendor.TaxId = "1";
newVendor.TaxIdisEIN = "Y";
newVendor.Telephone = vendor.Telephone != null ? vendor.Telephone : " ";
newVendor.ActiveFlag = "Y";
newVendor.AddressVerifiedFlag = "Y";
db.Vendors.Add(newVendor);
var ClientID = db.ClientUsers.Where(a => a.User == vendor.LoggedInUserID).Select(a => a.Client).FirstOrDefault();
var clientVendor = new ClientVendor();
clientVendor.ClientVendorId = Guid.NewGuid();
clientVendor.Client = ClientID;
clientVendor.Vendor = newVendor.VendorId;
clientVendor.ActiveFlag = "Y";
clientVendor.TaxDocument = vendor.TaxDocument;
clientVendor.FileName = vendor.TaxDocumentName;
var cgFileTyle = db.CGSFileTypes.Where(p => p.Decription.ToString().Trim().ToLower() == vendor.TaxDocumentType.Trim().ToLower()).FirstOrDefault();
if (cgFileTyle != null)
{
clientVendor.FileType = cgFileTyle.CGSFileTypesId;
}
db.ClientVendors.Add(clientVendor);
db.SaveChanges();
}
return(newVendor.VendorId);
}
catch (Exception ex)
{
throw (ex);
}
}
}
public List <ClientCustomerUsersEntity> GetClientCustomersUsers(Guid LoggedInUser)
{
List <ClientCustomerUsersEntity> ObjClientCustomersUsers = new List <ClientCustomerUsersEntity>();
using (FacilitiesEntities dB = new FacilitiesEntities())
{
var GetClient = dB.ClientUsers.Where(p => p.User == LoggedInUser).FirstOrDefault();
if (GetClient != null)
{
var GetCustomerAdminRole = dB.Roles.Where(p => p.RoleName.Trim() == "Customer Admin".Trim()).FirstOrDefault();
if (GetCustomerAdminRole != null)
{
ObjClientCustomersUsers = (from ClCust in dB.ClientCustomers
join CU in dB.CustomerUsers on ClCust.Customer equals CU.Customer
join U in dB.Users on CU.User equals U.UserId
join C in dB.Customers on ClCust.Customer equals C.CustomerId
where ClCust.Client == GetClient.Client && CU.Role == GetCustomerAdminRole.RoleId && C.ActiveFlag == "Y"
select new
{
_ClientID = ClCust.Client,
_CustomerID = ClCust.Customer,
_Customername = C.CustomerName,
_ClientCustomerID = ClCust.ClientCustomerId,
_RoleID = CU.Role,
_UserID = U.UserId,
_CustomerUserId = CU.CustomerUserId,
_ActiveFlag = U.ActiveFlag == "R" ? U.ActiveFlag : CU.ActiveFlag,
_Firstname = U.FirstName,
_Lastname = U.LastName,
_Email = U.Email
}
).ToList().Select(W => new ClientCustomerUsersEntity()
{
ClientCustomerID = W._ClientCustomerID,
ClientID = W._ClientID,
CustomerID = W._CustomerID,
Customername = W._Customername,
Email = W._Email,
Firstname = W._Firstname,
Lastname = W._Lastname,
RoleID = W._RoleID,
UserID = W._UserID,
CustomerUserId = W._CustomerUserId,
Status = UserStatus(W._ActiveFlag)
}).ToList();
}
}
}
return(ObjClientCustomersUsers);
}
//changes
public List <VendorEntities> GetClientVendors(Guid client)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
var GetAllClientVendors = (from V in db.Vendors
join VU in db.VendorUsers on V.VendorId equals VU.Vendor into temvu
from VU in temvu.DefaultIfEmpty()
join U in db.Users on VU.User equals U.UserId into temU
from U in temU.DefaultIfEmpty()
join CV in db.ClientVendors on V.VendorId equals CV.Vendor into tempVen
from CV in tempVen.DefaultIfEmpty()
where CV.Client == client
select new
{
VendorId = V.VendorId,
VendorName = V.VendorName,
Address01 = V.Address01,
Address02 = V.Address02,
City = V.City,
State = V.State,
Zip01 = V.Zip01,
Zip02 = V.Zip02,
Email = V.Email,
Telephone = V.Telephone,
TaxId = V.TaxId,
TaxIdisEIN = V.TaxIdisEIN,
ClientVendorId = CV.ClientVendorId,
_ActiveFlag = VU.Vendor == null ? CV.ActiveFlag : VU.ActiveFlag
}).ToList().Select(W => new VendorEntities()
{
Address01 = W.Address01,
Address02 = W.Address02,
City = W.City,
State = W.State,
Zip01 = W.Zip01,
Zip02 = W.Zip02,
VendorName = W.VendorName,
VendorId = W.VendorId,
Email = W.Email,
Telephone = W.Telephone,
TaxId = W.TaxId,
TaxIdisEIN = W.TaxIdisEIN,
ClientVendorId = W.ClientVendorId,
Status = UserStatus(W._ActiveFlag)
}).ToList();
return(GetAllClientVendors);
}
}
public IEnumerable <GetCustomerEmailAddressForInvoiceQuote_Result> GetAssociateCustomerLocationusers1(Guid LocationId)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
var CustomerLocationUsersList = db.GetCustomerEmailAddressForInvoiceQuote(LocationId).ToList();
return(CustomerLocationUsersList);
}
catch (Exception ex)
{
return(null);
}
}
}
public List <fn_getClientResourceData_Result> GetResourceEmailDetails(Guid ClientId, string item)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
var SalesTaxDetails = db.fn_getClientResourceData(ClientId, item).ToList();
return(SalesTaxDetails);
}
catch (Exception ex)
{
throw (ex);
}
}
}
public List <prc_GetPMWorkOrder_Result> GetWorkOrderData(Guid PMVendorId, Guid ClientId, Guid ClientPMHeaderId)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
var data = db.prc_GetPMWorkOrder(PMVendorId, ClientId, ClientPMHeaderId).ToList();
return(data);
}
catch (Exception ex)
{
throw (ex);
}
}
}
public List <prc_GetPMModuleDetails_Result> GetClientpmheadersData(Guid ClientId)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
var data = db.prc_GetPMModuleDetails(ClientId).ToList();
return(data);
}
catch (Exception ex)
{
throw (ex);
}
}
}
public List <prc_GetPMConfirmationData_Result> GetPMConfirnationData(Guid PmHeaderId)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
var data = db.prc_GetPMConfirmationData(PmHeaderId).ToList();
return(data);
}
catch (Exception ex)
{
throw (ex);
}
}
}
public CustomerLocationEntity GetLatestCustomerInformation(Guid PMVendorId)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
var UserLocation = (from PL in db.PMVendorCustomerLocations
join CL in db.CustomerLocations on PL.CustomerLocation equals CL.CustomerLocationId
join C in db.Customers on CL.Customer equals C.CustomerId
join PV in db.PMVendors on PL.PMVendor equals PV.PMVendorId
where PL.PMVendor == PMVendorId
select new
{
_PMVendorCustomerLocationId = PL.PMVendorCustomerLocationId,
_CustomerName = C.CustomerName,
_PMVendor = PL.PMVendor,
_CustomerLocationId = CL.CustomerLocationId,
_LocationName = CL.LocationName,
_LocationCode = CL.LocationCode,
_Address01 = CL.Address01,
_City = CL.City,
_State = CL.State,
_Zip01 = CL.Zip01,
_Telephone = CL.Telephone
}).ToList().Select(m => new CustomerLocationEntity()
{
PMVendorCustomerLocationId = m._PMVendorCustomerLocationId,
CustomerLocationId = m._CustomerLocationId,
LocationName = m._LocationName,
CustomerName = m._CustomerName,
LocationCode = m._LocationCode,
PMVendor = m._PMVendor,
Address01 = m._Address01,
City = m._City,
State = m._State,
Zip01 = m._Zip01,
Telephone = m._Telephone
}).FirstOrDefault();
return(UserLocation);
}
catch (Exception ex)
{
throw (ex);
}
}
}
//public DataTable GetWOConfirmationDate(string PmHeaderId)
//{
// SqlCommand objCmd;
// SqlDataAdapter da;
// using (FacilitiesEntities db = new FacilitiesEntities())
// {
// try
// {
// objCmd = new SqlCommand();
// //SqlConnection SLC = GetDBConnection();
// SqlConnection SLC = new SqlConnection(@"server = 173.248.153.60,1533; database = Facilities-dev; Integrated Security = false; connection timeout = 50; uid = FacilitiesUser; password = CP9p4Oietj3Ai");
// objCmd.Connection = SLC;
// SLC.Open();
// objCmd.CommandText = "prc_GetWOConfirmationDate";
// objCmd.CommandType = CommandType.StoredProcedure;
// objCmd.Parameters.AddWithValue("@PMHeaderId", PmHeaderId);
// // objCmd.Parameters.AddWithValue("@Frequency", Frequency);
// da = new SqlDataAdapter(objCmd);
// DataTable dt = new DataTable();
// da.Fill(dt);
// //var data = db.prc_GetWOConfirmationDate(PmHeaderId).ToList();
// var HeaderID = new Guid(PmHeaderId);
// foreach (DataRow value in dt.Rows)
// {
// PMWorkOrderCreationDate PMWCD = new PMWorkOrderCreationDate();
// PMWCD.PMWorkOrderCreationDateId = Guid.NewGuid();
// PMWCD.ClientPMHeader = HeaderID;
// PMWCD.WorkOrderCreationDate = Convert.ToDateTime(value["WorkOrderDate"]);
// PMWCD.WorkOrderArriveDate = Convert.ToDateTime(value["ArriveDateAndTime"]);
// PMWCD.WorkOrderFinishDate = Convert.ToDateTime(value["FinishDateAndTime"]);
// db.PMWorkOrderCreationDates.Add(PMWCD);
// db.SaveChanges();
// }
// //return da;
// return dt;
// }
// catch (Exception ex)
// {
// throw (ex);
// }
// }
//}
public bool UpdatePMConfirmation(Guid PMHeaderId)
{
try
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
var data = db.ClientPMHeaders.Where(a => a.ClientPMHeaderId == PMHeaderId).FirstOrDefault();
data.ActiveFlag = "Y";
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw (ex);
}
}
public IEnumerable <ClientCustomerUsersEntity> GetCustomerUserGridData(Guid CustomerId)
{
UOWManageUsers MU = new UOWManageUsers();
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
var CustomerUsers = (from cu in db.CustomerUsers
join c in db.Customers on cu.Customer equals c.CustomerId
join u in db.Users on cu.User equals u.UserId
join r in db.Roles on cu.Role equals r.RoleId
where c.CustomerId == CustomerId
select new
{
_CustomerID = c.CustomerId,
_Customername = c.CustomerName,
_RoleID = cu.Role,
_RoleName = r.RoleName,
_UserID = u.UserId,
_Firstname = u.FirstName,
_Lastname = u.LastName,
_Email = u.Email,
_ActiveFlag = u.ActiveFlag == "R" ? u.ActiveFlag : cu.ActiveFlag
}).ToList().Select(W => new ClientCustomerUsersEntity()
{
CustomerID = W._CustomerID,
Customername = W._Customername,
RoleID = W._RoleID,
RoleName = W._RoleName,
UserID = W._UserID,
Firstname = W._Firstname,
Lastname = W._Lastname,
Email = W._Email,
Status = MU.UserStatus(W._ActiveFlag)
}).ToList();
return(CustomerUsers);
}
catch (Exception ex)
{
return(null);
}
}
}
public IEnumerable <ClientVendorProblemClassEntity> GetClientVendorProblemClass(Guid ClientVendorId)
{
using (FacilitiesEntities db = new FacilitiesEntities())
{
var GetTaxandInsurance = (from CV in db.ClientVendorProblemClasses
where CV.ClientVendor == ClientVendorId
select new
{
_ClientVendorProblemClassesId = CV.ClientVendorProblemClassesId,
_ProblemClass = CV.ProblemClass
}).ToList().Select(W => new ClientVendorProblemClassEntity()
{
ClientVendorProblemClassesId = W._ClientVendorProblemClassesId,
ProblemClass = W._ProblemClass
}).ToList();
return(GetTaxandInsurance);
}
}
public bool IsCustomerExists(string Name)
{
bool exists = false;
using (FacilitiesEntities db = new FacilitiesEntities())
{
try
{
if (db.Customers.Any(x => x.CustomerName == Name))
{
exists = true;
}
}
catch (Exception ex)
{ }
}
return(exists);
}
