public bool SaveTaskWorkSpecification(Int64 intId, string strCustomId, string strDescription, string strTitle, string strURL, Int64 intTaskId, Int64 intParentTaskWorkSpecificationId, string strPassword = "")
{
bool blSuccess = true;
if (intTaskId > 0)
{
TaskWorkSpecification objTaskWorkSpecification = new TaskWorkSpecification();
objTaskWorkSpecification.Id = intId;
objTaskWorkSpecification.CustomId = strCustomId;
objTaskWorkSpecification.TaskId = intTaskId;
objTaskWorkSpecification.Description = Server.HtmlDecode(strDescription);
objTaskWorkSpecification.Title = strTitle;
objTaskWorkSpecification.URL = strURL;
// save will revoke freezed status.
objTaskWorkSpecification.AdminStatus = false;
objTaskWorkSpecification.TechLeadStatus = false;
if (strPassword.Equals(Convert.ToString(Session["loginpassword"])))
{
if (HttpContext.Current.Session["DesigNew"].ToString().ToUpper().Equals("ADMIN"))
{
objTaskWorkSpecification.AdminUserId = Convert.ToInt32(Session[JG_Prospect.Common.SessionKey.Key.UserId.ToString()]);
objTaskWorkSpecification.IsAdminInstallUser = JGSession.IsInstallUser.Value;
objTaskWorkSpecification.AdminStatus = true;
}
else if (HttpContext.Current.Session["DesigNew"].ToString().ToUpper().Equals("ITLEAD"))
{
objTaskWorkSpecification.TechLeadUserId = Convert.ToInt32(Session[JG_Prospect.Common.SessionKey.Key.UserId.ToString()]);
objTaskWorkSpecification.IsTechLeadInstallUser = JGSession.IsInstallUser.Value;
objTaskWorkSpecification.TechLeadStatus = true;
}
else
{
objTaskWorkSpecification.OtherUserId = Convert.ToInt32(Session[JG_Prospect.Common.SessionKey.Key.UserId.ToString()]);
objTaskWorkSpecification.IsOtherUserInstallUser = JGSession.IsInstallUser.Value;
objTaskWorkSpecification.OtherUserStatus = true;
}
}
if (intParentTaskWorkSpecificationId > 0)
{
objTaskWorkSpecification.ParentTaskWorkSpecificationId = intParentTaskWorkSpecificationId;
}
if (objTaskWorkSpecification.Id == 0)
{
TaskGeneratorBLL.Instance.InsertTaskWorkSpecification(objTaskWorkSpecification);
}
else
{
TaskGeneratorBLL.Instance.UpdateTaskWorkSpecification(objTaskWorkSpecification);
}
}
else
{
blSuccess = false;
}
return(blSuccess);
}
public int UpdateTaskWorkSpecificationStatusById(Int64 intId, string strPassword)
{
if (strPassword.Equals(Convert.ToString(Session["loginpassword"])))
{
TaskWorkSpecification objTaskWorkSpecification = new TaskWorkSpecification();
objTaskWorkSpecification.Id = intId;
bool blIsAdmin, blIsTechLead, blIsUser;
blIsAdmin = blIsTechLead = blIsUser = false;
if (HttpContext.Current.Session["DesigNew"].ToString().ToUpper().Equals("ADMIN"))
{
objTaskWorkSpecification.AdminUserId = Convert.ToInt32(Session[JG_Prospect.Common.SessionKey.Key.UserId.ToString()]);
objTaskWorkSpecification.IsAdminInstallUser = JGSession.IsInstallUser.Value;
objTaskWorkSpecification.AdminStatus = true;
blIsAdmin = true;
}
else if (HttpContext.Current.Session["DesigNew"].ToString().ToUpper().Equals("ITLEAD"))
{
objTaskWorkSpecification.TechLeadUserId = Convert.ToInt32(Session[JG_Prospect.Common.SessionKey.Key.UserId.ToString()]);
objTaskWorkSpecification.IsTechLeadInstallUser = JGSession.IsInstallUser.Value;
objTaskWorkSpecification.TechLeadStatus = true;
blIsTechLead = true;
}
else
{
objTaskWorkSpecification.OtherUserId = Convert.ToInt32(Session[JG_Prospect.Common.SessionKey.Key.UserId.ToString()]);
objTaskWorkSpecification.IsOtherUserInstallUser = JGSession.IsInstallUser.Value;
objTaskWorkSpecification.OtherUserStatus = true;
blIsUser = true;
}
return(TaskGeneratorBLL.Instance.UpdateTaskWorkSpecificationStatusById
(
objTaskWorkSpecification,
blIsAdmin,
blIsTechLead,
blIsUser
));
}
else
{
return(-2);
}
}
public int UpdateTaskWorkSpecificationStatusById(TaskWorkSpecification objTaskWorkSpecification, bool blIsAdmin, bool blIsTechLead, bool blIsUser)
{
return(TaskGeneratorDAL.Instance.UpdateTaskWorkSpecificationStatusById(objTaskWorkSpecification, blIsAdmin, blIsTechLead, blIsUser));
}
public int UpdateTaskWorkSpecification(TaskWorkSpecification objTaskWorkSpecification)
{
return(TaskGeneratorDAL.Instance.UpdateTaskWorkSpecification(objTaskWorkSpecification));
}
public int InsertTaskWorkSpecification(TaskWorkSpecification objTaskWorkSpecification)
{
return(TaskGeneratorDAL.Instance.InsertTaskWorkSpecification(objTaskWorkSpecification));
}
public object GetTaskWorkSpecifications(Int32 TaskId, Int64 intParentTaskWorkSpecificationId)
{
List <string> strTableData = new List <string>();
DataSet ds = new DataSet();
if (intParentTaskWorkSpecificationId == 0)
{
ds = TaskGeneratorBLL.Instance.GetTaskWorkSpecifications(TaskId, App_Code.CommonFunction.CheckAdminAndItLeadMode(), null, 0, null);
}
else
{
ds = TaskGeneratorBLL.Instance.GetTaskWorkSpecifications(TaskId, App_Code.CommonFunction.CheckAdminAndItLeadMode(), intParentTaskWorkSpecificationId, 0, null);
}
TaskWorkSpecification[] arrTaskWorkSpecification = null;
string strFirstParentCustomId = "";
string strLastCustomId = "";
int intTotalRecordCount = 0;
if (ds.Tables.Count == 4)
{
arrTaskWorkSpecification = new TaskWorkSpecification[ds.Tables[0].Rows.Count];
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
arrTaskWorkSpecification[i] = new TaskWorkSpecification();
arrTaskWorkSpecification[i].Id = Convert.ToInt64(dr["Id"]);
arrTaskWorkSpecification[i].CustomId = Convert.ToString(dr["CustomId"]);
arrTaskWorkSpecification[i].AdminStatus = Convert.ToBoolean(dr["AdminStatus"]);
arrTaskWorkSpecification[i].TechLeadStatus = Convert.ToBoolean(dr["TechLeadStatus"]);
arrTaskWorkSpecification[i].OtherUserStatus = Convert.ToBoolean(dr["OtherUserStatus"]);
arrTaskWorkSpecification[i].Description = Convert.ToString(dr["Description"]);
arrTaskWorkSpecification[i].Title = Convert.ToString(dr["Title"]);
arrTaskWorkSpecification[i].URL = Convert.ToString(dr["URL"]);
if (!string.IsNullOrEmpty(dr["ParentTaskWorkSpecificationId"].ToString()))
{
arrTaskWorkSpecification[i].ParentTaskWorkSpecificationId = Convert.ToInt64(dr["ParentTaskWorkSpecificationId"]);
}
arrTaskWorkSpecification[i].TaskWorkSpecificationsCount = Convert.ToInt32(dr["SubTaskWorkSpecificationCount"]);
}
intTotalRecordCount = Convert.ToInt32(ds.Tables[1].Rows[0]["TotalRecordCount"]);
if (ds.Tables[2].Rows.Count > 0)
{
strFirstParentCustomId = Convert.ToString(ds.Tables[2].Rows[0]["FirstParentCustomId"]);
}
if (ds.Tables[3].Rows.Count > 0)
{
strLastCustomId = Convert.ToString(ds.Tables[3].Rows[0]["LastChildCustomId"]);
}
}
string strNextCustomId = string.Empty;
if (string.IsNullOrEmpty(strFirstParentCustomId) || intParentTaskWorkSpecificationId == 0)
{
strNextCustomId = App_Code.CommonFunction.GetTaskWorkSpecificationSequence("A", strLastCustomId);
}
// parent list has alphabetical numbering.
else if (strFirstParentCustomId.Equals("A"))
{
strNextCustomId = App_Code.CommonFunction.GetTaskWorkSpecificationSequence("1", strLastCustomId);
}
// parent list has decimal numbering.
else if (strFirstParentCustomId.Equals("1"))
{
strNextCustomId = App_Code.CommonFunction.GetTaskWorkSpecificationSequence("1a", strLastCustomId);
}
// parent list has custom numbering.
else if (strFirstParentCustomId.Equals("1a"))
{
strNextCustomId = App_Code.CommonFunction.GetTaskWorkSpecificationSequence("1", strLastCustomId);
}
// parent list has roman numbering.
else if (strFirstParentCustomId.Equals("i") || strFirstParentCustomId.Equals("I"))
{
strNextCustomId = App_Code.CommonFunction.GetTaskWorkSpecificationSequence("a", strLastCustomId);
}
else
{
strNextCustomId = App_Code.CommonFunction.GetTaskWorkSpecificationSequence("I", strLastCustomId, true);
}
int intPendingCount = 0;
DataSet dsTaskSpecificationStatus = TaskGeneratorBLL.Instance.GetPendingTaskWorkSpecificationCount(TaskId);
if (dsTaskSpecificationStatus.Tables.Count > 1 && dsTaskSpecificationStatus.Tables[1].Rows.Count > 0)
{
intPendingCount = Convert.ToInt32(dsTaskSpecificationStatus.Tables[1].Rows[0]["PendingRecordCount"]);
}
var result = new
{
NextCustomId = strNextCustomId,
TotalRecordCount = intTotalRecordCount,
PendingCount = intPendingCount,
Records = arrTaskWorkSpecification
};
return(result);
}
