//Method for creating new task.
public int CreateProjectTaskDetail(TaskDetail projectTaskDetail)
{
//adding data to attechment table
var attachment = new LegaSys_Attachments
{
AttachmentPath = projectTaskDetail.AttachmentPath,
Title = projectTaskDetail.TaskTitle,
Description = projectTaskDetail.Description,
Created_Date = (projectTaskDetail.Created_Date != null) ? projectTaskDetail.Created_Date : DateTime.Now,
AttachmentTypeID = attachmentTypeId
};
db.LegaSys_Attachments.Add(attachment);
//declaration of object attachmentType
var Typeattachment = new LegaSys_AttachmentTypes
{
AttachmentType = projectTaskDetail.AttachmentType,
Description = projectTaskDetail.Description,
Created_Date = (projectTaskDetail.Created_Date != null) ? projectTaskDetail.Created_Date : DateTime.Now,
};
db.LegaSys_AttachmentTypes.Add(Typeattachment);
//adding data to project task table
var taskModel = new LegaSys_ProjectTasks
{
Title = projectTaskDetail.TaskTitle,
Description = projectTaskDetail.Description,
//fk need dropdown from project TABLE DATASOURCE
Attachment_ID = attachmentid,
//fk need dropdown from project TABLE DATASOURCE
Project_ID = projectTaskDetail.Project_ID,
Created_By = projectTaskDetail.Created_By,
Updated_By = projectTaskDetail.Updated_By,
Created_Date = (projectTaskDetail.Created_Date != null)?projectTaskDetail.Created_Date:DateTime.Now,
Updated_Date = projectTaskDetail.Updated_Date,
};
//assingment of Global variable to access in any table
attachmentid = attachment.AttachmentID;
attachmentTypeId = Typeattachment.AttachmentTypeID;
db.LegaSys_ProjectTasks.Add(taskModel);
db.SaveChanges();
return(taskModel.ProjectTaskID);
}
public UserLoginDetails AuthenticateAndFetchUserDetail(string Username, string Password)
{
//validate user credentials
var user = (from login in db.LegaSys_UserLogin.Where(x => x.IsActive.Value)
join details in db.LegaSys_UserDetails.Where(x => x.IsActive) on login.UserDetailID equals details.UserDetailID
where login.Username.ToLower().Trim() == Username.ToLower().Trim() && login.Password.Trim() == Password.Trim()
select new
{
login,
details
}).FirstOrDefault();
if (user == null)
{
return(null);
}
var lastLogin = user.login.LastLogin;
user.login.LastLogin = DateTime.Now;
db.SaveChanges();
return(new UserLoginDetails
{
UserDetailID = user.details.UserDetailID,
Username = user.login.Username,
Name = user.details.Firstname,
LastLogin = lastLogin
});
}
public void RegisterException(HttpRequestMessage request, HttpRequestContext requestContext, Exception ex)
{
string endpointResponse = null;
if (ex is WebException)
{
using (var rs = new StreamReader(((WebException)ex).Response.GetResponseStream()))
{
endpointResponse = rs.ReadToEnd();
}
}
var log = new LegaSys_ErrorLogs
{
IsHandled = true,
ResourceUri = request.RequestUri.AbsoluteUri,
QueryString = request.RequestUri.AbsoluteUri.GetQueryString(),
ErrorDatetimeUtc = DateTime.UtcNow,
ErrorMessage = ex.Message,
ExceptionDetail = ex.InnerException?.GetExceptionMessages() ?? string.Empty,
StackTrace = ex.StackTrace,
IpAddress = request.GetClientIpAddress(),
UserID = requestContext.Principal?.Identity.Name,
ReferingUrl = request.Headers.Referrer?.AbsoluteUri,
UserAgent = request.Headers.UserAgent?.ToString()
};
if (!string.IsNullOrEmpty(endpointResponse))
{
log.ExceptionDetail += Environment.NewLine + Environment.NewLine + endpointResponse;
}
db.LegaSys_ErrorLogs.Add(log);
db.SaveChanges();
}
public int CreateProjectDetail(ProjectDetail projectDetail)
{
var projectModel = new LegaSys_Projects
{
Title = projectDetail.Title,
Description = projectDetail.Description,
Client_ID = projectDetail.Client_ID,
ProjectDomain_ID = projectDetail.ProjectDomain_ID,
Status = 0,//projectDetail.Status,
Created_By = projectDetail.Created_By,
Updated_By = projectDetail.Updated_By,
Created_Date = DateTime.Now, //projectDetail.Created_Date,
Updated_Date = DateTime.Now, //projectDetail.Updated_Date,
};
db.LegaSys_Projects.Add(projectModel);
db.SaveChanges();
return(projectModel.ProjectID);
}
public int AddClientDetails(ClientDetail Objclient)
{
//Insert User details
int Result = 0;
try
{
var model = new LegaSys_ClientDetails
{
ClientDetailID = Objclient.ClientDetailID,
ClientName = Objclient.ClientName,
Address = Objclient.Address,
Country = Objclient.Country,
CoClient = Objclient.CoClient,
CoClient2 = Objclient.CoClient2,
CoClient3 = Objclient.CoClient3,
CoClient4 = Objclient.CoClient4,
EmailID = Objclient.EmailID,
EmailID2 = Objclient.EmailID2,
EmailID3 = Objclient.EmailID3,
EmailID4 = Objclient.EmailID4,
Created_By = Objclient.Created_By,
Updated_By = Objclient.Updated_By,
Created_Date = System.DateTime.UtcNow,
Updated_Date = System.DateTime.UtcNow,
IsActive = true
};
db.LegaSys_ClientDetails.Add(model);
db.SaveChanges();
return(Result = model.ClientDetailID);
}
catch (Exception)
{
Result = 0;
}
return(Result);
}
public bool ChangeStatus(int id)
{
var location = db.LegaSys_Master_Locations.FirstOrDefault(x => x.LocationID == id);
if (location == null)
{
return(false);
}
if (location.IsActive)
{
location.IsActive = false;
}
else
{
location.IsActive = true;
}
db.SaveChanges();
return(true);
}
public bool ChangeStatus(int id)
{
var domain = db.LegaSys_Master_TechDomains.FirstOrDefault(x => x.TechDomainID == id);
if (domain == null)
{
return(false);
}
if (domain.IsActive)
{
domain.IsActive = false;
}
else
{
domain.IsActive = true;
}
db.SaveChanges();
return(true);
}
public bool ChangeStatus(int id)
{
var shift = db.LegaSys_Master_Shifts.FirstOrDefault(x => x.ShiftID == id);
if (shift == null)
{
return(false);
}
if (shift.IsActive)
{
shift.IsActive = false;
}
else
{
shift.IsActive = true;
}
db.SaveChanges();
return(true);
}
public bool ChangeStatus(int id)
{
var technology = db.LegaSys_Master_Technologies.FirstOrDefault(x => x.TechnologyID == id);
if (technology == null)
{
return(false);
}
if (technology.IsActive)
{
technology.IsActive = false;
}
else
{
technology.IsActive = true;
}
db.SaveChanges();
return(true);
}
public bool ChangeStatus(int id)
{
var role = db.LegaSys_Master_Roles.FirstOrDefault(x => x.UserRoleID == id);
if (role == null)
{
return(false);
}
if (role.IsActive)
{
role.IsActive = false;
}
else
{
role.IsActive = true;
}
db.SaveChanges();
return(true);
}
public int CreateResoure(UserDetail userDetail)
{
var model = new LegaSys_UserDetails
{
Firstname = userDetail.Firstname,
Middlename = userDetail.Middlename,
Lastname = userDetail.Lastname,
TotalExp = userDetail.TotalExp,
EmailId = userDetail.EmailId,
MobileNumber = userDetail.MobileNumber,
Master_Location_ID = userDetail.Master_Location_ID,
Master_Shift_ID = userDetail.Master_Shift_ID,
ReportingHead_ID = userDetail.ReportingHead_ID,
Master_Role_ID = userDetail.Master_Role_ID,
Remarks = userDetail.Remarks,
Created_Date = DateTime.Now,
Created_By = userDetail.Created_By,
IsActive = true
};
db.SaveChanges();
return(model.UserDetailID);
}
public bool ChangeLeavetypeStatus(int id)
{
var leave = db.LegaSys_Master_LeaveTypes.FirstOrDefault(x => x.LeaveTypeID == id);
if (leave == null)
{
return(false);
}
if (leave.IsActive)
{
leave.IsActive = false;
}
else
{
leave.IsActive = true;
}
db.SaveChanges();
return(true);
}