public TEProjectUnitModel Get(int id)
{
TEProjects_UNIT item = db.TEProjects_UNIT.Find(id);
TEProjectUnitModel model = new TEProjectUnitModel();
TETransformEntityNModel translator = new TETransformEntityNModel();
model = translator.TransformAtoB(item, model);
#region Commented due to entity change
//if (item.PROJECT_ID.Value > 0)
//{
// TEProject pro = db.TEProjects.Find(item.PROJECT_ID.Value);
// if (pro != null)
// model.Project = new TEProject
// {
// Uniqueid = pro.Uniqueid,
// ProjectCode = pro.ProjectCode,
// ProjectName = pro.ProjectName,
// ProjectShortName = pro.ProjectShortName,
// ProjectStatus = pro.ProjectStatus,
// IsNewProject = pro.IsNewProject,
// City = pro.City,
// COLOURCODE = pro.COLOURCODE,
// };
//}
#endregion
if (item.TOWERID != null)
{
TEProjects_TOWER tower = db.TEProjects_TOWER.Find(item.TOWERID);
if (tower != null)
{
model.Tower = new TEProjects_TOWER
{
Uniqueid = tower.Uniqueid,
TOWERNAME = tower.TOWERNAME,
TOWERCODE = tower.TOWERCODE,
DESCRIPTION = tower.DESCRIPTION
}
}
;
}
return(model);
}
public TEProjects_UNIT Post(TEProjects_UNIT value)
{
TEProjects_UNIT result = value;
if (!(value.Uniqueid + "".Length > 0))
{
result.CreatedOn = System.DateTime.Now;
result.LastModifiedOn = System.DateTime.Now;
result = db.TEProjects_UNIT.Add(value);
}
else
{
db = new TEHRIS_DevEntities();
db.TEProjects_UNIT.Attach(value);
foreach (System.Reflection.PropertyInfo item in result.GetType().GetProperties())
{
string propname = item.Name;
if (propname.ToLower() == "createdon")
{
continue;
}
object propValue = item.GetValue(value);
if (propValue != null || Convert.ToString(propValue).Length != 0)
{
db.Entry(value).Property(propname).IsModified = true;
}
}
value.LastModifiedOn = System.DateTime.Now;
db.Entry(value).Property(x => x.LastModifiedOn).IsModified = true;
}
db.SaveChanges();
return(db.TEProjects_UNIT.Find(value.Uniqueid));
}
public object SendNotifications(TENotificationModel value)
{
try
{
TEProjects_UNIT ProjectUnit = db.TEProjects_UNIT.Where(x => (x.PROJECT_ID == value.Project) &&
(x.TOWERID == Convert.ToInt32(value.Tower)) &&
(x.AREA == value.unit)).ToList().First();
if (ProjectUnit != null)
{
List <TEContact> contact = db.TEContacts.Where(x => (x.Projectid == value.Project) &&
(x.Towerid == value.Tower) &&
(x.Unitid == value.unit)).ToList();
if (contact != null)
{
foreach (var item in contact)
{
UserProfile userprof = db.UserProfiles.Where(x => (x.email == item.Emailid)).ToList().First();
if (userprof != null)
{
value.ReceivedBy = userprof.UserId;
value.Status = "Active";
SendNotification(value);
}
}
}
}
else
{
List <TEProjects_TOWER> ProjectTower = db.TEProjects_TOWER.Where(x => (x.PROJECT_ID == value.Project) &&
(x.Uniqueid == Convert.ToInt32(value.Tower))).ToList();
if (ProjectTower != null)
{
List <TEContact> contact = db.TEContacts.Where(x => (x.Projectid == value.Project) &&
(x.Towerid == value.Tower)).ToList();
if (contact != null)
{
foreach (var item in contact)
{
UserProfile userprof = db.UserProfiles.Where(x => (x.email == item.Emailid)).ToList().First();
if (userprof != null)
{
value.ReceivedBy = userprof.UserId;
value.Status = "Active";
SendNotification(value);
}
}
}
}
else
{
#region Commented due to entity change
//List<TEProject> Project = db.TEProjects.Where(x => (x.Uniqueid == value.Project)).ToList();
//if (ProjectTower != null)
//{
// List<TEContact> contact = db.TEContacts.Where(x => (x.Projectid == value.Project)).ToList();
// if (contact != null)
// {
// foreach (var item in contact)
// {
// UserProfile userprof = db.UserProfiles.Where(x => (x.email == item.Emailid)).ToList().First();
// if (userprof != null)
// {
// value.ReceivedBy = userprof.UserId;
// value.Status = "Active";
// SendNotification(value);
// }
// }
// }
//}
#endregion
}
}
}
catch (Exception ex)
{
try
{
List <TEProjects_TOWER> ProjectTower = db.TEProjects_TOWER.Where(x => (x.PROJECT_ID == value.Project) &&
(x.Uniqueid == Convert.ToInt32(value.Tower))).ToList();
if (ProjectTower != null)
{
List <TEContact> contact = db.TEContacts.Where(x => (x.Projectid == value.Project) &&
(x.Towerid == value.Tower)).ToList();
if (contact != null)
{
foreach (var item in contact)
{
UserProfile userprof = db.UserProfiles.Where(x => (x.email == item.Emailid)).ToList().First();
if (userprof != null)
{
value.ReceivedBy = userprof.UserId;
value.Status = "Active";
SendNotification(value);
}
}
}
}
else
{
#region Commented due to entity change
//List<TEProject> Project = db.TEProjects.Where(x => (x.Uniqueid == value.Project)).ToList();
//if (Project != null)
//{
// List<TEContact> contact = db.TEContacts.Where(x => (x.Projectid == value.Project)).ToList();
// if (contact != null)
// {
// foreach (var item in contact)
// {
// UserProfile userprof = db.UserProfiles.Where(x => (x.email == item.Emailid)).ToList().First();
// if (userprof != null)
// {
// value.ReceivedBy = userprof.UserId;
// value.Status = "Active";
// SendNotification(value);
// }
// }
// }
//}
#endregion
}
}
catch (Exception ex1)
{
#region Commented due to entity change
//try
//{
//List<TEProject> Project = db.TEProjects.Where(x => (x.Uniqueid == value.Project)).ToList();
//if (Project != null)
//{
// List<TEContact> contact = db.TEContacts.Where(x => (x.Projectid == value.Project)).ToList();
// if (contact != null)
// {
// foreach (var item in contact)
// {
// UserProfile userprof = db.UserProfiles.Where(x => (x.email == item.Emailid)).ToList().First();
// if (userprof != null)
// {
// value.ReceivedBy = userprof.UserId;
// value.Status = "Active";
// SendNotification(value);
// }
// }
// }
// }
//}
//catch(Exception ex2)
//{
// db.ApplicationErrorLogs.Add(
// new ApplicationErrorLog
// {
// Error = ex.Message,
// ExceptionDateTime = System.DateTime.Now,
// InnerException = ex.InnerException != null ? ex.InnerException.Message : "",
// Source = "From TENotifications API | AddNotifications | " + this.GetType().ToString(),
// Stacktrace = ex.StackTrace
// }
// );
//}
#endregion
}
}
db.SaveChanges();
return("success");
}
public object SendContact(TEUnit_Onboarding value)
{
TEUnit_Onboarding unit = db.TEUnit_Onboarding.Where(x => x.Uniqueid == value.Uniqueid).ToList().First();
UserProfile userinfo = db.UserProfiles.Where(x => x.UserId == unit.UserID).ToList().First();
if (userinfo != null)
{
int?tower = 0;
try
{
TEProjects_UNIT projectunit = db.TEProjects_UNIT.Where(x => (x.PROJECT_ID == value.Project) &&
(x.AREA == value.Unit)).ToList().First();
if (projectunit != null)
{
tower = projectunit.TOWERID;
}
}
catch (Exception ex)
{
ex.Message.ToString();
}
TEContact contact = new TEContact
{
ApprovedBy = userinfo.CallName,
ApprovedOn = System.DateTime.Now,
CreatedBy = userinfo.CallName,
CreatedOn = System.DateTime.Now,
//Have to be dynamic...
IsDeleted = false,
LastModifiedBy = userinfo.CallName,
LastModifiedOn = System.DateTime.UtcNow,
Projectid = value.Project,
Towerid = tower,
Unitid = value.Unit,
Mobile = userinfo.Phone,
Emailid = userinfo.email,
DOB = System.DateTime.Now,
DOM = System.DateTime.Now,
Type = "",
PrefferedContact = "",
PrefferedMode = "",
ISProfileSPublic = false,
IsAdvertise = false,
Photo = userinfo.photo,
Salutation = "",
FirstName = "",
MiddleName = "",
LastName = "",
CallName = userinfo.CallName,
ContactType = "",
Nationality = "",
CountryOfBirth = "",
Age = 0,
Gender = "",
MaritalStatus = "",
Category = "",
Importance = "",
PrefferedSaleConsultant = "",
TEOrganisation = 0,
Status = value.Status,
//Type
};
return(db.TEContacts.Add(contact));
}
return("Success");
}
