public int deletetaskbyid(int id)
{
int retVal = 0;
AccountSpecificTask _taskDtl = null;
User tasks = new User();
using (var db = new EvolutyzCornerDataEntities())
{
try
{
tasks = db.Set <User>().Where(s => s.Usr_TaskID == id).FirstOrDefault <User>();
_taskDtl = db.Set <AccountSpecificTask>().Where(s => s.Acc_SpecificTaskId == id).FirstOrDefault <AccountSpecificTask>();
if (tasks != null)
{
return(retVal = 2);
}
if (_taskDtl == null)
{
return(retVal);
}
_taskDtl.isDeleted = true;
db.Entry(_taskDtl).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
retVal = 1;
}
catch (Exception ex)
{
retVal = -1;
}
}
return(retVal);
}
public string SaveTasks(string Acc_AccountID, string tsk_TaskID, string Acc_SpecificTaskName, string StatusId)
{
string strresponse = "";
int accid = Convert.ToInt32(Acc_AccountID);
if (tsk_TaskID == "" || Acc_SpecificTaskName == "" || StatusId == "")
{
return(strresponse = "Please Fill All Mandatory Fields");
}
int taskid = Convert.ToInt32(tsk_TaskID);
int sttus = Convert.ToInt32(StatusId);
bool b = Convert.ToBoolean(sttus);
UserSessionInfo infoobj = new UserSessionInfo();
int userid = infoobj.UserId;
try
{
using (var db = new EvolutyzCornerDataEntities())
{
AccountSpecificTask orgCheck = db.Set <AccountSpecificTask>().Where(s => (s.Acc_SpecificTaskName == Acc_SpecificTaskName && s.AccountID == accid)).FirstOrDefault <AccountSpecificTask>();
if (orgCheck != null)
{
return(strresponse = "Already Task Existed");
}
db.Set <AccountSpecificTask>().Add(new AccountSpecificTask
{
AccountID = accid,
Acc_SpecificTaskName = Acc_SpecificTaskName,
tsk_TaskID = taskid,
//StatusId = ,
isDeleted = b,
CreatedBy = userid,
CreatedDate = DateTime.Now
});
db.SaveChanges();
strresponse = "Successfully Added";
}
}
catch (Exception ex)
{
throw ex;
}
return(strresponse);
}
public string UpdateTasks(int id, string ProjectId, string tsk_TaskID, string Proj_SpecificTaskName, string StatusId)
{
string strresponse = "";
try
{
int projectid = Convert.ToInt32(ProjectId);
int taskid = Convert.ToInt32(tsk_TaskID);
int sttus = Convert.ToInt32(StatusId);
bool b = Convert.ToBoolean(sttus);
UserSessionInfo infoobj = new UserSessionInfo();
int userid = infoobj.UserId;
using (var db = new EvolutyzCornerDataEntities())
{
AccountSpecificTask taskdetails = db.Set <AccountSpecificTask>().Where(s => s.Acc_SpecificTaskId == id).FirstOrDefault <AccountSpecificTask>();
if (taskdetails == null)
{
return(null);
}
taskdetails.AccountID = projectid;
taskdetails.tsk_TaskID = taskid;
taskdetails.isDeleted = b;
taskdetails.Acc_SpecificTaskName = Proj_SpecificTaskName;
taskdetails.ModifiedBy = userid;
taskdetails.ModifiedDate = System.DateTime.Now;
db.Entry(taskdetails).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
strresponse = "Tasks successfully updated";
}
}
catch (Exception ex)
{
throw ex;
}
return(strresponse);
}
//History
#region To get particular Task details from Database
//public List<History_tasksEntity> GetHistoryTaskDetailsByID(int ID)
//{
// using (var db = new EvolutyzCornerDataEntities())
// {
// try
// {
// var query = (from q in db.History_tasks
// where q.History_tsk_taskID == ID
// select new History_tasksEntity
// {
// History_task_ID = q.History_task_ID,
// History_tsk_taskID = q.History_tsk_taskID,
// History_tsk_taskName = q.History_tsk_taskName,
// History_tsk_taskDescription = q.History_tsk_taskDescription,
// History_tsk_ActiveStatus = q.History_tsk_ActiveStatus,
// History_tsk_Version = q.History_tsk_Version,
// History_tsk_CreatedBy = q.History_tsk_CreatedBy,
// History_tsk_CreatedDate = q.History_tsk_CreatedDate,
// History_tsk_ModifiedBy = q.History_tsk_ModifiedBy,
// History_tsk_ModifiedDate = q.History_tsk_ModifiedDate,
// History_tsk_isDeleted = q.History_tsk_isDeleted,
// }).OrderBy(x => x.History_tsk_taskName).ToList();
// return query;
// }
// catch (Exception ex)
// {
// return null;
// }
// }
//}
#endregion
public string ChangeStatus(string id, string status)
{
string strResponse = string.Empty;
AccountSpecificTask holidayData = null;
bool Status = Convert.ToBoolean(status);
int did = Convert.ToInt32(id);
using (var db = new DbContext(CONNECTION_NAME))
{
try
{
holidayData = db.Set <AccountSpecificTask>().Where(s => s.Acc_SpecificTaskId == did).FirstOrDefault <AccountSpecificTask>();
if (holidayData == null)
{
return(null);
}
holidayData.isDeleted = Status;
// holidayData.isActive = false;
db.Entry(holidayData).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
if (status == "true")
{
strResponse = "Status Changed to InActive";
}
else
{
strResponse = "Status Changed to Active";
}
//strResponse = "Status Changed Successfully";
}
catch (Exception ex)
{
strResponse = ex.Message.ToString();
}
}
return(strResponse);
}
