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); }