/// <summary>
/// checkApprovalExitOrNot
/// </summary>
public void checkApprovalExitOrNot()
{
#region Enable ChangeRequest Button
StatusFence.Text = "";
StatusFence.Visible = false;
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowChangeRequestHH;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Session["PROJECT_ID"]), ChangeRequestCode);
int userID = Convert.ToInt32(Session["USER_ID"]);
int ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
int HHID = Convert.ToInt32(Session["HH_ID"]);
if (objWorkFlowBO != null)
{
string paramChangeRequest = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, "HVFEN");
lnkFence.Attributes.Add("onclick", paramChangeRequest);
lnkFence.Visible = true;
}
else
{
lnkFence.Visible = false;
}
#endregion
getApprrequtStatusDamageCrops();
}
private SubmitEnterpriseViewModel EnterpriseInit(int?pageIndex)
{
pageIndex = pageIndex ?? 1;
string pager = string.Empty;
int pageSize = 14;
SubmitEnterpriseViewModel viewModel = new SubmitEnterpriseViewModel();
#region where
Dictionary <KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>, object> where = new Dictionary <KeyValuePair <string, SQLFilterType>, object>();
if (!string.IsNullOrWhiteSpace(Request["name"]))
{
where.Add(new KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>("Name", RoadFlow.Data.Model.SQLFilterType.IN), Request["name"]);
viewModel.ParaName = Request["name"];
}
#endregion
DataTable buildings = BuildingsDataBLL.GetCurrentUsersOrganizeList(pageIndex.Value, pageSize, where, out pager);
viewModel.List = buildings;
viewModel.Pager = pager;
WorkFlowBLL workFlowBLL = new WorkFlowBLL();
viewModel.CreateFlowID = workFlowBLL.GetByName("企业入驻").ID;
DataTable houses = ElementOrganizeBLL.GetCurrentBuildingModify();
viewModel.ToStreetID = GetToStreetID(houses);
return(viewModel);
}
/// <summary>
/// Check Approval Exit Or Not
/// </summary>
public void checkApprovalExitOrNot()
{
#region Enable ChangeRequest Button
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowCdapBudget;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Session["PROJECT_ID"]), ChangeRequestCode);
int userID = Convert.ToInt32(Session["USER_ID"]);
int ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
int HHID = Convert.ToInt32(Session["HH_ID"]);
if (objWorkFlowBO != null)
{
btnApproval.Visible = true;
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Approver is not Defined');", true);
btnApproval.Visible = false;
}
#endregion
}
public void checkApprovalExitOrNot()
{
#region Enable ChangeRequest Button
StatusInstitution.Text = "";
StatusInstitution.Visible = false; // used to display the Status if you send Request for change data
// getApprovalChangerequestStatus(); //To make Visible Save and Cancle Button by checking Approve status
//for checking Change Request Approver Exit or not
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowChangeRequestHH;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Session["PROJECT_ID"]), ChangeRequestCode);
int userID = Convert.ToInt32(Session["USER_ID"]);
int ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
int HHID = Convert.ToInt32(Session["HH_ID"]);
//string pageCode = "HH-LU";
if (objWorkFlowBO != null)
{
string paramChangeRequest = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, "HHINS");
lnkHHInstitution.Attributes.Add("onclick", paramChangeRequest);
lnkHHInstitution.Visible = true;
}
else
{
lnkHHInstitution.Visible = false;
}
#endregion
getApprrequtStatusInstitution();
}
public void Delete(int I_Owner)
{
using (WorkFlowBLL workFlowBLL = new WorkFlowBLL())
{
workFlowBLL.Usp_Workflow_Delete(I_Owner);
}
}
/// <summary>
/// check For Approver Exists or Not
/// </summary>
/// <returns></returns>
public bool checkForApprover()
{
string NegotiatedAmount = string.Empty;
//for checking Change Request Approver Exit or not
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
bool approverExists = false;
string ChangeRequestCode = UtilBO.WorkflowPaymentRequest;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Session["PROJECT_ID"]), ChangeRequestCode);
if (objWorkFlowBO != null)
{
approverExists = true;
//EnableSubmitButton(true);
//if (hdnPendingRequestCount.Value != null)
//{
// int CountPendingRecords = Convert.ToInt32(hdnPendingRequestCount.Value);
// if (CountPendingRecords == 0)
// EnableSubmitButton(false);
// else
// EnableSubmitButton(true);
//}
}
else
{
EnableSubmitButton(false);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Approver is not defined')", true);
}
return(approverExists);
}
private SubmitBuildingModifyViewModel BuildingModifyInit(int?pageIndex)
{
pageIndex = pageIndex ?? 1;
string pager = string.Empty;
int pageSize = 14;
SubmitBuildingModifyViewModel viewModel = new SubmitBuildingModifyViewModel();
DataTable houses = ElementOrganizeBLL.GetCurrentBuildingModify();
if (houses.Rows.Count == 0)
{
viewModel.Message = "该用户还没有分配权限，可以联系商务局相关人员询问具体情况。";
return(viewModel);
}
#region where
Dictionary <KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>, object> where = new Dictionary <KeyValuePair <string, SQLFilterType>, object>();
if (!string.IsNullOrWhiteSpace(Request["name"]))
{
where.Add(new KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>("Name", RoadFlow.Data.Model.SQLFilterType.CHARINDEX), Request["name"]);
viewModel.ParaName = Request["name"];
}
#endregion
DataTable dt = BuildingsDataBLL.GetCurrentUsersOrganizeList(pageIndex.Value, pageSize, where, out pager);
viewModel.List = dt;
viewModel.Pager = pager;
DictionaryBLL dictionaryBLL = new DictionaryBLL();
viewModel.HouseName = dictionaryBLL.GetListByCode("LPMC");
viewModel.HouseName.PrimaryKey = new DataColumn[] { viewModel.HouseName.Columns["ID"] };
WorkFlowBLL workFlowBLL = new WorkFlowBLL();
viewModel.EditFlowID = workFlowBLL.GetByName("楼栋更新").ID;
viewModel.ToStreetID = GetToStreetID(houses);
return(viewModel);
}
/// <summary>
/// Set Grid Data source
/// </summary>
/// <param name="addRow"></param>
/// <param name="deleteRow"></param>e
public void BindGridWorkFlowDefinition()
{
//TRN_WORKFLOW_DEFINITION
string projectID = Session["PROJECT_ID"].ToString();
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
grdWorkflowItem.DataSource = WorkFlowBLLobj.GetWorkFlowDefinition(projectID);
grdWorkflowItem.DataBind();
}
/// <summary>
/// Set Grid Data source
/// </summary>
/// <param name="addRow"></param>
/// <param name="deleteRow"></param>e
private void BindGrid(bool addRow, bool deleteRow)
{
string projectID = Session["PROJECT_ID"].ToString();
string WorkflowDefID = ViewState["WorkFlowDefID"].ToString();
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
grdApprover.DataSource = WorkFlowBLLobj.GetApprover(projectID, WorkflowDefID);
grdApprover.DataBind();
}
private SubmitEnterpriseModifyViewModel EnterpriseModifyInit(int?pageIndex)
{
pageIndex = pageIndex ?? 1;
string pager = string.Empty;
int pageSize = 14;
SubmitEnterpriseModifyViewModel viewModel = new SubmitEnterpriseModifyViewModel();
DataTable houses = ElementOrganizeBLL.GetCurrentBuildingModify();
if (houses.Rows.Count == 0)
{
viewModel.Message = "该用户还没有分配权限，可以联系商务局相关人员询问具体情况。";
return(viewModel);
}
DataTable buildings = null;//用于根据楼栋列表查询对应的企业列表
#region where
Dictionary <KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>, object> where = new Dictionary <KeyValuePair <string, SQLFilterType>, object>();
if (!string.IsNullOrWhiteSpace(Request["buildingID"]))
{
viewModel.ParaBuildingID = Request["buildingID"];
buildings = BuildingsDataBLL.GetByStringID(Request["buildingID"]);
}
else
{
buildings = BuildingsDataBLL.GetCurrentUsersOrganizeList();
}
if (!string.IsNullOrWhiteSpace(Request["name"]))
{
where.Add(new KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>("Name", RoadFlow.Data.Model.SQLFilterType.CHARINDEX), Request["name"]);
viewModel.ParaName = Request["name"];
}
#endregion
#region 用于view中的显示楼栋名称和所属楼栋列表
viewModel.BuildingsName = BuildingsDataBLL.GetCurrentUsersOrganizeList();
viewModel.BuildingsName.PrimaryKey = new DataColumn[] { viewModel.BuildingsName.Columns["ID"] };
#endregion
//获取企业列表（带翻页）
if (buildings == null || buildings.Rows.Count == 0)
{
viewModel.Message = "需要先新增楼栋信息。";
return(viewModel);
}
DataTable list = new EnterpriseAndEnterpriseTaxBLL().GetAllByBuildings(buildings, pageIndex.Value, pageSize, where, out pager);
viewModel.List = list;
viewModel.Pager = pager;
WorkFlowBLL workFlowBLL = new WorkFlowBLL();
viewModel.EditFlowID = workFlowBLL.GetByName("企业更新").ID;
viewModel.DeleteFlowID = workFlowBLL.GetByName("企业搬出").ID;
viewModel.ToStreetID = GetToStreetID(houses);
return(viewModel);
}
/// <summary>
/// method to bind data to ModuleDropDownList from database
/// </summary>
public void getModule()
{
WorkFlowBO objWorkFlow = new WorkFlowBO();
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
WorkFlowList objWorkFlowList = new WorkFlowList();
objWorkFlowList = WorkFlowBLLobj.getAllModule();
ddlModuleDropDownList.DataSource = objWorkFlowList;//dt.Tables[0];
ddlModuleDropDownList.DataTextField = "MODULENAME";
ddlModuleDropDownList.DataValueField = "MODULEID";
ddlModuleDropDownList.DataBind();
ddlModuleDropDownList.Items.Insert(0, new ListItem("-- Select --", "0"));
ddlModuleDropDownList.SelectedIndex = 0;
}
/// <summary>
/// method to softdelete approver
/// </summary>
/// <returns></returns>
private int DeleteApprover()
{
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
int WORKFLOWDEFID = 0;
int Result = 0;
if (ViewState["WorkApprovalID"] != null)
{
WORKFLOWDEFID = Convert.ToInt32(ViewState["WorkApprovalID"].ToString());
}
if (WORKFLOWDEFID != 0)
{
Result = WorkFlowBLLobj.DeleteApprover(WORKFLOWDEFID);
ViewState["WorkApprovalID"] = null;
}
return(Result);
}
private SubmitIndexViewModel IndexInit()
{
SubmitIndexViewModel viewModel = new SubmitIndexViewModel();
//获取当前用户所属组织有的楼盘权限
DataTable dt = ElementOrganizeBLL.GetCurrentBuildingModify();
viewModel.List = dt;
DictionaryBLL dictionaryBLL = new DictionaryBLL();
viewModel.HouseName = dictionaryBLL.GetListByCode("LPMC");
viewModel.HouseName.PrimaryKey = new DataColumn[] { viewModel.HouseName.Columns["ID"] };
WorkFlowBLL workFlowBLL = new WorkFlowBLL();
viewModel.CreateFlowID = workFlowBLL.GetByName("楼栋报送").ID;
viewModel.ToStreetID = GetToStreetID(dt);
return(viewModel);
}
/// <summary>
/// 保存流程数据
/// </summary>
/// <param name="flowEngine">流程</param>
/// <param name="category">分类</param>
/// <param name="owner">具体业务数据对应的PK</param>
public void FlowSave(Eastday.WorkFlowEngine.FlowEngine flowEngine)
{
using (WorkFlowBLL workFlowBLL = new WorkFlowBLL())
{
workFlowBLL.DbContext = workFlowBLL.CreateDbContext(true);
WorkFlowEntity workFlowEntity = workFlowBLL.Usp_Flow_ByOwner(flowEngine.Attachment.Owner);
if (workFlowEntity == null)
{
workFlowEntity = new WorkFlowEntity();
}
workFlowEntity.I_Owner = flowEngine.Attachment.Owner;
workFlowEntity.I_State = (int)flowEngine.FlowState;
workFlowEntity.I_Flag = 1;
//ParticipantEntity
var aCurrent = flowEngine.GetCurrent();
var steps = from step in flowEngine.FlowSteps where !(step is StepEnd) select step;
List <ParticipantEntity> participants = new List <ParticipantEntity>();
foreach (var step in steps)
{
foreach (var node in step.Nodes)
{
ParticipantEntity participantEntity = new ParticipantEntity();
participantEntity.I_Reference = node.Participant.Reference;
participantEntity.I_WorkFlow = workFlowEntity.Id;
participantEntity.C_Step = step.Identification;
participantEntity.C_Node = node.Identification;
participantEntity.I_Auditer = node.Conclusion.Auditer;
participantEntity.D_Audit = node.Conclusion.AuditDate;
participantEntity.I_Bind = node.Participant.Category;
participantEntity.I_Current = step == aCurrent && node.AuditType == AuditType.UnAudit ? 1 : (int)node.Conclusion.AuditType;
participants.Add(participantEntity);
}
}
if (workFlowBLL.Usp_Flow_Insert(workFlowEntity, participants) > 0)
{
workFlowBLL.DbContext.CommitTransaction();
this.Save(flowEngine);
}
}
}
/// <summary>
/// method to bind data to HightAuthDropDownList from database
/// </summary>
public void getAllProjectPersonUser()
{
WorkFlowBO objWorkFlow = new WorkFlowBO();
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
WorkFlowList objWorkFlowList = new WorkFlowList();
string projectID = Session["PROJECT_ID"].ToString();
objWorkFlowList = WorkFlowBLLobj.getAllProjectPersonUser(projectID);
ListItem lstItem1 = HightAuthDropDownList.Items[0];
HightAuthDropDownList.Items.Clear();
HightAuthDropDownList.DataSource = objWorkFlowList;//dt.Tables[0];
HightAuthDropDownList.DataTextField = "UserName";
HightAuthDropDownList.DataValueField = "UserID";
HightAuthDropDownList.DataBind();
HightAuthDropDownList.Items.Insert(0, lstItem1);
}
/// <summary>
/// method to bind data to WorkflowItemDropDownList from database
/// </summary>
public void getWorkfolwitemByModuleID()
{
int ModuleID = Convert.ToInt32(ModuleDropDownList.SelectedItem.Value.ToString());
WorkFlowBO objWorkFlow = new WorkFlowBO();
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
WorkFlowList objWorkFlowList = new WorkFlowList();
objWorkFlowList = WorkFlowBLLobj.GetWorkFlowByModuleId(ModuleID);
ListItem lstItem = WorkflowItemDropDownList.Items[0];
WorkflowItemDropDownList.Items.Clear();
WorkflowItemDropDownList.DataSource = objWorkFlowList;//dt.Tables[0];
WorkflowItemDropDownList.DataTextField = "WorkDesc";
WorkflowItemDropDownList.DataValueField = "WorkflowID";
WorkflowItemDropDownList.DataBind();
WorkflowItemDropDownList.Items.Insert(0, lstItem);
}
/// <summary>
/// method to fetch values from grid and assign to textbox
/// </summary>
private void GetApprover()
{
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
int WORKAPPROVALID = 0;
if (ViewState["WorkApprovalID"] != null)
{
WORKAPPROVALID = Convert.ToInt32(ViewState["WorkApprovalID"]);
}
if (WORKAPPROVALID != 0)
{
WorkFlowBO WorkFlowObj = new WorkFlowBO();
WorkFlowObj = WorkFlowBLLobj.GetWorkFlowById(WORKAPPROVALID);
ApproverRoleNameDropDownList.ClearSelection();
if (ApproverRoleNameDropDownList.Items.FindByValue(WorkFlowObj.RoleID.ToString()) != null)
{
ApproverRoleNameDropDownList.Items.FindByValue(WorkFlowObj.RoleID.ToString()).Selected = true;
}
int RoleID = WorkFlowObj.RoleID;
getUserByRoleID(RoleID);
ApproverNameDropDownList.ClearSelection();
if (ApproverNameDropDownList.Items.FindByValue(WorkFlowObj.UserID.ToString()) != null)
{
ApproverNameDropDownList.Items.FindByValue(WorkFlowObj.UserID.ToString()).Selected = true;
}
ApproverLevelDropDownList.ClearSelection();
if (ApproverLevelDropDownList.Items.FindByValue(WorkFlowObj.LEVEL.ToString()) != null)
{
ApproverLevelDropDownList.Items.FindByValue(WorkFlowObj.LEVEL.ToString()).Selected = true;
}
ApproverLevelDropDownList.Enabled = false;
WorkApproverIDTextBox.Text = WorkFlowObj.WorkApprovalID.ToString();
WorkDefinationTextBox.Text = WorkFlowObj.WorkFlowDefID.ToString();
}
}
/// <summary>
/// To open Email Pop up Window
/// </summary>
public void openEmailPopupWindow()
{
int HHIDIN_ = 0;
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowCdapBudget;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Session["PROJECT_ID"]), ChangeRequestCode);
int userID = Convert.ToInt32(Session["USER_ID"]);
int ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
int HHID = HHIDIN_; //Convert.ToInt32(Session["HH_ID"]);
string pageCode = "CDAPB";
if (objWorkFlowBO != null)
{
string paramChangeRequest = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, pageCode);
ClientScript.RegisterStartupScript(this.GetType(), "CDAPBREQ", paramChangeRequest, true);
}
}
/// <summary>
/// method to fetch userdetails based on roleid
/// </summary>
/// <param name="roleID"></param>
public void getUserByRoleID(int roleID)
{
WorkFlowBO objWorkFlow = new WorkFlowBO();
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
WorkFlowList objWorkFlowList = new WorkFlowList();
int projectID = Convert.ToInt32(Session["PROJECT_ID"].ToString());
//int roleID_ = roleID;
objWorkFlowList = WorkFlowBLLobj.getApprovalRoleUserID(projectID, roleID);
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.DataSource = objWorkFlowList;//dt.Tables[0];
ApproverNameDropDownList.DataTextField = "ApproverUserName";
ApproverNameDropDownList.DataValueField = "ApproverUserID";
ApproverNameDropDownList.DataBind();
ApproverNameDropDownList.Items.Insert(0, lstItem);
}
private SubmitMonthModifyViewModel MonthInfoModifyInit(int?pageIndex)
{
pageIndex = pageIndex ?? 1;
string pager = string.Empty;
int pageSize = 14;
SubmitMonthModifyViewModel viewModel = new SubmitMonthModifyViewModel();
#region where
Dictionary <KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>, object> where = new Dictionary <KeyValuePair <string, SQLFilterType>, object>();
if (!string.IsNullOrWhiteSpace(Request["name"]))
{
where.Add(new KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>("Name", RoadFlow.Data.Model.SQLFilterType.CHARINDEX), Request["name"]);
viewModel.ParaName = Request["name"];
}
if (!string.IsNullOrWhiteSpace(Request["timeArea"]))
{
where.Add(new KeyValuePair <string, RoadFlow.Data.Model.SQLFilterType>("TimeArea", RoadFlow.Data.Model.SQLFilterType.EQUAL), Request["timeArea"].Replace("-", ""));
viewModel.ParaTimeArea = Request["timeArea"];
}
#endregion
BuildingMonthInfoDataBLL buildingMonthInfoDataBLL = new BuildingMonthInfoDataBLL();
DataTable dt = buildingMonthInfoDataBLL.GetPagerData(out pager, pageSize, pageIndex.Value, where);
viewModel.List = dt;
viewModel.Pager = pager;
WorkFlowBLL workFlowBLL = new WorkFlowBLL();
viewModel.EditFlowID = workFlowBLL.GetByName("每月更新").ID;
//通过BuildingID获取关联的街道ID
Dictionary <string, object> dictionary = new Dictionary <string, object>();
foreach (DataRow dr in dt.Rows)
{
DataTable streets = ElementOrganizeBLL.GetToStreetByBuildingID(dr["BuildingID"]);
if (streets.Rows.Count != 0)
{
dictionary.Add(dr["BuildingID"].ToString(), streets.Rows[0]["OrganizeID"]);
}
}
viewModel.ToStreetID = dictionary;
return(viewModel);
}
/// <summary>
/// method to bind data to ApproverRoleNameDropDownList from database
/// </summary>
public void getAllRole()
{
WorkFlowBO objWorkFlow = new WorkFlowBO();
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
WorkFlowList objWorkFlowList = new WorkFlowList();
string projectID = Session["PROJECT_ID"].ToString();
objWorkFlowList = WorkFlowBLLobj.getAllEmpName(projectID);
ListItem lstItem = ApproverRoleNameDropDownList.Items[0];
ApproverRoleNameDropDownList.Items.Clear();
ApproverRoleNameDropDownList.DataSource = objWorkFlowList;//dt.Tables[0];
ApproverRoleNameDropDownList.DataTextField = "RoleName";
ApproverRoleNameDropDownList.DataValueField = "RoleID";
ApproverRoleNameDropDownList.DataBind();
ApproverRoleNameDropDownList.Items.Insert(0, lstItem);
ApproverRoleNameDropDownList.SelectedIndex = 0;
//Comment add by Ramu under gudines of amalesh
//HightAuthDropDownList
}
/// <summary>
/// Check Approvar Exist or not
/// </summary>
public void checkApprovalExitOrNot()
{
#region Enable ChangeRequest Button
lblCompensationPackageStatus.Text = string.Empty;
lblCompensationPackageStatus.Visible = false;
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowPackageReview;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Session["PROJECT_ID"]), ChangeRequestCode);
int userID = Convert.ToInt32(Session["USER_ID"]);
int ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
int HHID = Convert.ToInt32(Session["HH_ID"]);
string pageCode = "CPREV";
if (objWorkFlowBO != null)
{
string paramChangeRequest = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, pageCode);
lnkValuationPCI.Attributes.Add("onclick", paramChangeRequest);
lnkValuationPCI.Visible = true;
ViewState["ApproveExists"] = "Yes";
}
else
{
lnkValuationPCI.Visible = false;
ViewState["ApproveExists"] = "No";
lblCompensationPackageStatus.Visible = true;
lblCompensationPackageStatus.ForeColor = System.Drawing.Color.Red;
lblCompensationPackageStatus.Text = "Package Review Approver Not Defined";
}
#endregion
getAppoverReqStatusPakClos();
}
/// <summary>
/// To Load Scrren
/// </summary>
public void ScreenLoading()
{
string CR_PreText = "Change Request For ";
string ResultValue = string.Empty;
string FormName = string.Empty;
string PAGECODE = string.Empty;
string NegotiatedAmount = string.Empty;
string emailSubject = "";
string changeRequestCode = Request.QueryString["ChangeRequestCode"];
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Request.QueryString["ProjectID"]), changeRequestCode);
if (objWorkFlowBO != null)
{
if (Request.QueryString["pageCode"] != null)
{
PageCodeTextBox.Text = Request.QueryString["pageCode"].ToString();
}
HHIDTextBox.Text = Request.QueryString["HHID"];
if (changeRequestCode == "CR-HH")
{
switch (PageCodeTextBox.Text)
{
case "HH":
FormName = CR_PreText + "Household Details of HHID " + HHIDTextBox.Text;
break;
//case "":
// FormName = CR_PreText + ""; break;
case "HH-AV":
FormName = CR_PreText + "Acreage Valution"; break;
case "HH-GOS":
FormName = CR_PreText + "Group Ownership"; break;
case "HHGMS":
FormName = CR_PreText + "Group Member"; break;
case "HHTRD":
FormName = CR_PreText + "Holder Type Details"; break;
case "HH-SA":
FormName = CR_PreText + "Services on Affected Plot"; break;
case "HH-LU":
FormName = CR_PreText + "Affected Land Users"; break;
case "HHINS":
FormName = CR_PreText + "House Hold Institute"; break;
case "HHLHH":
FormName = CR_PreText + "House Hold Land Holding"; break;
case "HHMCE":
FormName = CR_PreText + ""; break;
case "HLIOF":
FormName = CR_PreText + ""; break;
case "HLION":
FormName = CR_PreText + "Land Info Resident On"; break;
case "HH-MS":
FormName = CR_PreText + "Major Shocks"; break;
case "HHNEH":
FormName = CR_PreText + "Neighbours"; break;
case "HH-HD":
FormName = CR_PreText + "Health Disability"; break;
case "HHHIF":
FormName = CR_PreText + "Health Info"; break;
case "HH-SE":
FormName = CR_PreText + "Socio Economy"; break;
case "HHSEL":
FormName = CR_PreText + "PAP Livelihood"; break;
case "HHSBD":
FormName = CR_PreText + "Status Bank"; break;
case "HH-SC":
FormName = CR_PreText + "Social Concern"; break;
case "GRIEV":
FormName = CR_PreText + "Grievances"; break;
case "HV-CO":
FormName = CR_PreText + "Valuation Crops"; break;
case "HVCUP":
FormName = CR_PreText + "Cultural Properties"; break;
case "HVDAC":
FormName = CR_PreText + "Damaged Crops"; break;
case "HVFEN":
FormName = CR_PreText + "Fence"; break;
case "HFVAL":
FormName = CR_PreText + ""; break;
case "HV-GR":
FormName = CR_PreText + "Grave"; break;
//case "HVNPS":
// FormName = CR_PreText + ""; break; //Not Used
case "HVOFX":
FormName = CR_PreText + "Other Fixtures"; break;
case "HVPBU":
FormName = CR_PreText + "Permanent Bulding"; break;
//case "PKREV":
// FormName = CR_PreText + "Payment"; break;
//case "CDAPB":
// FormName = CR_PreText + "Email Popup"; break;
//case "CPREV":
// FormName = CR_PreText + "Compensation Package Review"; break;
//case "CRFND":
// FormName = CR_PreText + "Payment Request"; break;
//case "CREND":
// FormName = CR_PreText + "Payment Verification"; break;
//case "RTA":
// FormName = CR_PreText + "Root Approval"; break;
//case "DATAV":
// FormName = CR_PreText + "Data Verification"; break;
//case "":
// FormName = CR_PreText + ""; break;
default:
FormName = CR_PreText + "HouseHolD";
break;
}
}
else if (changeRequestCode == "NEG")
{
FormName = "Change Request for Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (changeRequestCode == "NEGC")
{
FormName = "Change Request for Crops Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (changeRequestCode == "NEGL")
{
FormName = "Change Request for Land Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (changeRequestCode == "NEGF")
{
FormName = "Change Request for Fixtures Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (changeRequestCode == "NEGR")
{
FormName = "Change Request for Replacement Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (changeRequestCode == "NEGD")
{
FormName = "Change Request for Damaged crop Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (changeRequestCode == "NEGCU")
{
FormName = "Change Request for Cultural Property Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (Request.QueryString["ChangeRequestCode"] == "RFPRI")
{
FormName = "Request for Printing the Package Document for HHID " + HHIDTextBox.Text;
}
else
{
FormName = objWorkFlowBO.EmailSubject;
}
if (Request.QueryString["ChangeRequestCode"] == "PAYRQ")
{
if (Request.QueryString["BatchNo"] != null)
{
ViewState["BatchNo"] = Request.QueryString["BatchNo"];
}
}
else if (Request.QueryString["ChangeRequestCode"] == UtilBO.WorkflowGrievances)
{
if (Request.QueryString["GrievanceID"] != null)
{
ViewState["GrievanceID"] = Request.QueryString["GrievanceID"];
}
else
{
ViewState["GrievanceID"] = "0";
}
}
emailSubject = FormName;
Master.PageHeader = FormName;
EmailToTextBox.Text = objWorkFlowBO.EmailID;
EmailSubjectTextBox.Text = emailSubject;
WorkFlowApproverIDTextBox.Text = objWorkFlowBO.WorkFlowApproverID.ToString();
StatusIDTextBox.Text = "3";
ApproverUserIdTextBox.Text = objWorkFlowBO.ApproverUserID.ToString();
WorkFlowDefinitionIDTextBox.Text = objWorkFlowBO.WorkFlowDefinitionID.ToString();
ProjectCodeTextBox.Text = objWorkFlowBO.ProjectCode.ToString();
ProjectNameTextBox.Text = objWorkFlowBO.ProjectName.ToString();
//For DIsplaying in TextBox
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("Dear Sir / Madam,");
sb.Append(System.Environment.NewLine);
sb.Append(objWorkFlowBO.EmailBody);
sb.Append(System.Environment.NewLine);
if (Request.QueryString["pageCode"] == "NEG")
{
sb.Append(FormName); sb.Append(" Negotiated Amount : ");
sb.Append(NegotiatedAmount);
}
else if (Request.QueryString["pageCode"].ToString().Length >= 3 && Request.QueryString["pageCode"].Substring(0, 3) == "NEG")
{
sb.Append(FormName); sb.Append(" Negotiated Amount : ");
sb.Append(NegotiatedAmount);
}
sb.Append(System.Environment.NewLine);
sb.Append("Project Code : " + objWorkFlowBO.ProjectCode);
sb.Append(System.Environment.NewLine);
sb.Append("Project Name : " + objWorkFlowBO.ProjectName);
sb.Append(System.Environment.NewLine);
sb.Append(" Thanks and Regards");
sb.Append(System.Environment.NewLine);
sb.Append("WIS - UETCL Team");
string InputEmail = sb.ToString();
string mailContent = InputEmail;
mailContent = mailContent.Replace("\\n", "<br>");
EmailBodyTextBox.Text = mailContent;
}
else
{
if (Request.QueryString["ChangeRequestCode"] == "NEG")
{
ClientScript.RegisterStartupScript(this.GetType(), "EMAILPOPUP", "AfterNogAmount();", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Aftersend", "Aftersend();", true);
}
}
}
/// <summary>
/// Set edit mode for edit comand
/// Delete data from the database for delete comand
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdApprover_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
ViewState["WorkApprovalID"] = e.CommandArgument;
ADDButton.Visible = false;
UpDateButton.Visible = true;
CancelButton.Visible = true;
GetApprover();
;
}
else if (e.CommandName == "DeleteRow")
{
ViewState["WorkApprovalID"] = e.CommandArgument;
int level = 0;
int sameLavel = 0;
GridViewRow row = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer;
Literal litWorkApprovallevel = (Literal)row.FindControl("litWorkApprovallevel");
WorkFlowBLL WorkFlowBLLOBJ = new WorkFlowBLL();
WorkFlowList WorkFlowList = new WorkFlowList();
string projectID = Session["PROJECT_ID"].ToString();
string WorkflowDefID = ViewState["WorkFlowDefID"].ToString();
WorkFlowList = WorkFlowBLLOBJ.GetApprover(projectID, WorkflowDefID);
for (int i = 0; i < WorkFlowList.Count; i++)
{
level = (WorkFlowList[i].LEVEL);
if (level == (Convert.ToInt32(litWorkApprovallevel.Text.ToString())))
{
sameLavel = 0;
}
else
{
sameLavel = 1;
}
}
WorkFlowList = WorkFlowBLLOBJ.GetApprover(projectID, WorkflowDefID);
if (sameLavel == 0)
{
if (Convert.ToInt32(ViewState["WorkApprovalID"]) != 0)
{
int result = 0;
result = DeleteApprover();
if (result == 0)
{
string message = "Approver Already in use";
string AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
else if (result == -1)
{
string message = "Data Deleted successfully";
string AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
BindGrid(false, true);
ADDButton.Visible = true;
UpDateButton.Visible = false;
CancelButton.Visible = false;
getAllRole();
getLevel();
}
}
else
{
string message = "Delete Higher Level Approver First";
string AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
}
}
/// <summary>
/// To save or edit details to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ADDButton_Click(object sender, EventArgs e)
{
string message = string.Empty;
string AlertMessage = string.Empty;
WorkFlowBLL WorkFlowBLLOBJ = new WorkFlowBLL();
WorkFlowList WorkFlowList = new WorkFlowList();
int level = 0;
int count;
int sameLavel = 0;
string projectID = Session["PROJECT_ID"].ToString();
string testWorkflowDefID = ViewState["WorkFlowDefID"].ToString();
string WorkflowDefID = ViewState["WorkFlowDefID"].ToString();
WorkFlowList = WorkFlowBLLOBJ.GetApprover(projectID, WorkflowDefID);
if (WorkFlowList.Count == 0)
{
level = level + 1;
if (level == (Convert.ToInt32(ApproverLevelDropDownList.SelectedItem.Value.ToString())))
{
sameLavel = 0;
}
else
{
sameLavel = 1;
}
}
else
{
for (int i = 0; i < WorkFlowList.Count; i++)
{
if (WorkApproverIDTextBox.Text != "0")
{
level = (WorkFlowList[i].LEVEL);
if (level == (Convert.ToInt32(ApproverLevelDropDownList.SelectedItem.Value.ToString())))
{
sameLavel = 0;
}
else
{
sameLavel = 1;
break;
}
}
else
{
level = (WorkFlowList[i].LEVEL) + 1;
if (level == (Convert.ToInt32(ApproverLevelDropDownList.SelectedItem.Value.ToString())))
{
sameLavel = 0;
}
else
{
sameLavel = 1;
}
}
}
}
if (WorkApproverIDTextBox.Text != "0")
{
#region for update
if (sameLavel == 0)
{
string uID = Session["USER_ID"].ToString();
string pID = Session["PROJECT_ID"].ToString();
WorkFlowBO objWorkFlow = new WorkFlowBO();
objWorkFlow.ApprovalID = Convert.ToInt32(ApproverRoleNameDropDownList.SelectedItem.Value.ToString());
objWorkFlow.ApproverUserID = Convert.ToInt32(ApproverNameDropDownList.SelectedItem.Value.ToString());
objWorkFlow.LEVEL = Convert.ToInt32(ApproverLevelDropDownList.SelectedItem.Value.ToString());
objWorkFlow.UserID = Convert.ToInt32(uID);
objWorkFlow.ProjectID = Convert.ToInt32(pID);
objWorkFlow.WorkFlowDefID = Convert.ToInt32(WorkDefinationTextBox.Text.ToString());
objWorkFlow.WorkApprovalID = Convert.ToInt32(ViewState["WorkApprovalID"]);
count = WorkFlowBLLOBJ.EditAPPROVALADD(objWorkFlow);
if (count == 1)
{
message = "Approver or Level Already Exists";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
BindGrid(true, true);
ADDButton.Visible = true;
UpDateButton.Visible = false;
CancelButton.Visible = false;
WorkApproverIDTextBox.Text = "0";
WorkDefinationTextBox.Text = "0";
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
ApproverLevelDropDownList.Enabled = true;
}
else if (count == -1)
{
message = "Approver updated successfully";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
BindGrid(true, true);
ADDButton.Visible = true;
UpDateButton.Visible = false;
CancelButton.Visible = false;
WorkApproverIDTextBox.Text = "0";
WorkDefinationTextBox.Text = "0";
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
ApproverLevelDropDownList.Enabled = true;
}
}
else
{
message = "Approver or Level Already Exists";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
BindGrid(true, true);
ADDButton.Visible = true;
UpDateButton.Visible = false;
CancelButton.Visible = false;
WorkApproverIDTextBox.Text = "0";
WorkDefinationTextBox.Text = "0";
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
ApproverLevelDropDownList.Enabled = true;
//getAllRole();
}
getAllRole();
getLevel();
#endregion
}
else
{
#region For Save
try
{
if (sameLavel == 0)
{
string uID = Session["USER_ID"].ToString();
string pID = Session["PROJECT_ID"].ToString();
WorkFlowBO objWorkFlow = new WorkFlowBO();
objWorkFlow.ApprovalID = Convert.ToInt32(ApproverRoleNameDropDownList.SelectedItem.Value.ToString());
objWorkFlow.ApproverUserID = Convert.ToInt32(ApproverNameDropDownList.SelectedItem.Value.ToString());
objWorkFlow.LEVEL = Convert.ToInt32(ApproverLevelDropDownList.SelectedItem.Value.ToString());
objWorkFlow.UserID = Convert.ToInt32(uID);
objWorkFlow.ProjectID = Convert.ToInt32(pID);
objWorkFlow.WorkFlowDefID = Convert.ToInt32(ViewState["WorkFlowDefID"]);
count = WorkFlowBLLOBJ.InsertAPPROVALADD(objWorkFlow);
if (count == 1)
{
message = "Approver or Level Already Exists";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
BindGrid(true, true);
getAllRole();
getLevel();
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
}
else if (count == -1)
{
message = "Approver Added successfully";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
BindGrid(true, true);
getAllRole();
getLevel();
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
}
}
else
{
message = " Approvers are Not Defined for Previous Level(s) ";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
BindGrid(true, true);
getAllRole();
getLevel();
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
WorkFlowBLLOBJ = null;
}
#endregion
}
}
/// <summary>
/// Set edit mode for edit comand
/// Delete data from the database for delete comand
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdProjects_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditProject")
{
Session["PROJECT_ID"] = e.CommandArgument;
Session["FROZEN"] = null;
getFrozen();
Session["PROJECT_CODE"] = ((LinkButton)e.CommandSource).Text;
Session["HH_ID"] = null;
if (Request.QueryString["mode"] == "redir")
{
Response.Redirect(ResolveUrl("~/UI/Compensation/PAPList.aspx"));
}
else if (Request.QueryString["mode"] == "redirCDAP")
{
Response.Redirect(ResolveUrl("~/UI/Compensation/CDAPImplementation.aspx"));
}
else
{
if (CheckAuthorization.HasUpdatePrivilege(UtilBO.PrivilegeCode.CREATE_PROJECT) == false &&
CheckAuthorization.HasViewPrivilege(UtilBO.PrivilegeCode.CREATE_PROJECT) == false)
{
Response.Redirect(ResolveUrl("~/UI/Compensation/PAPList.aspx"));
}
else
{
Response.Redirect("ProjectDetails.aspx");
}
}
}
else if (e.CommandName == "FreezeProject")
{
ProjectBLL ObjProjectBLL = new ProjectBLL();
ObjProjectBLL.FreezeProject(Convert.ToInt32(e.CommandArgument), Convert.ToInt32(Session["USER_ID"]));
Session["FROZEN"] = null;
getFrozen();
BindProjects(false);
}
else if (e.CommandName == "DataVerificationProject")
{
string message = string.Empty;
// Session["PROJECT_ID"] = e.CommandArgument;
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowDataVerification;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(e.CommandArgument), ChangeRequestCode);
string pageCode = "DATAV";
if (objWorkFlowBO != null)
{
int userID = Convert.ToInt32(Session["USER_ID"]);
int ProjectID = Convert.ToInt32(e.CommandArgument);
int HHID = Convert.ToInt32(Session["HH_ID"]);
string paramChangeRequest = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, pageCode);
ClientScript.RegisterStartupScript(this.GetType(), "DATAVERIFICATIONPROJECT", paramChangeRequest, true);
}
else
{
message = "Data Verification Approval is not defined";
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
}
else if (e.CommandName == "Unfreeze")
{
//Call the Popwindow here
int ProjectId = 0;
string ProjectCode = string.Empty;
string CommandArguments = e.CommandArgument.ToString();
string[] strArguments = e.CommandArgument.ToString().Split(new char[] { ',' });
if (strArguments.Length > 1)
{
ProjectId = Convert.ToInt32(strArguments[0]);
ProjectCode = strArguments[1];
}
string callUnfreezeWindow = string.Format("UnfreezeWindow({0},'{1}',{2})", ProjectId, ProjectCode, Convert.ToInt32(Session["USER_ID"]));
ClientScript.RegisterStartupScript(this.GetType(), "callUnfreezeWindow", callUnfreezeWindow, true);
BindProjects(false);
}
}
/// <summary>
/// Set edit mode for edit comand
/// Delete data from the database for delete comand
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdWorkflowItem_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
ViewState["WorkFlowDefID"] = e.CommandArgument;
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
objWorkFlowBO = objWorkFlowBLL.GetWorkFlowDefByID(Convert.ToInt32(ViewState["WorkFlowDefID"]));
//Editing set the value to the respective dropDown box and textbox
if (objWorkFlowBO != null)
{
ModuleDropDownList.ClearSelection();
if (ModuleDropDownList.Items.FindByValue(objWorkFlowBO.ModuleID.ToString()) != null)
{
ModuleDropDownList.Items.FindByValue(objWorkFlowBO.ModuleID.ToString()).Selected = true;
}
getWorkfolwitemByModuleID();
WorkflowItemDropDownList.ClearSelection();
if (WorkflowItemDropDownList.Items.FindByValue(objWorkFlowBO.WorkflowID.ToString()) != null)
{
WorkflowItemDropDownList.Items.FindByValue(objWorkFlowBO.WorkflowID.ToString()).Selected = true;
}
getAllRole();
HightAuthDropDownList.ClearSelection();
if (HightAuthDropDownList.Items.FindByValue(objWorkFlowBO.HigherAuthorityID.ToString()) != null)
{
HightAuthDropDownList.Items.FindByValue(objWorkFlowBO.HigherAuthorityID.ToString()).Selected = true;
}
getLevel();
ApproverLevelDropDownList.ClearSelection();
if (ApproverLevelDropDownList.Items.FindByValue(objWorkFlowBO.ApprovalID.ToString()) != null)
{
ApproverLevelDropDownList.Items.FindByValue(objWorkFlowBO.ApprovalID.ToString()).Selected = true;
}
getLevel();
TriggerDropDownList.ClearSelection();
if (TriggerDropDownList.Items.FindByValue(objWorkFlowBO.Trigger.ToString()) != null)
{
TriggerDropDownList.Items.FindByValue(objWorkFlowBO.Trigger.ToString()).Selected = true;
}
AfterDropDownList.ClearSelection();
if (AfterDropDownList.Items.FindByValue(objWorkFlowBO.AfterDays.ToString()) != null)
{
AfterDropDownList.Items.FindByValue(objWorkFlowBO.AfterDays.ToString()).Selected = true;
}
if (HightAuthDropDownList.SelectedIndex > 0)
{
TriggerDropDownList.Enabled = true;
AfterDropDownList.Enabled = true;
}
else
{
TriggerDropDownList.Enabled = false;
AfterDropDownList.Enabled = false;
}
WORKFLOWDEFINITIONIDTextBox.Text = objWorkFlowBO.WorkFlowDefID.ToString();
SaveButton.Text = "Update";
ClearButton.Text = "Cancel";
}
SetUpdateMode(true);
}
else if (e.CommandName == "DeleteRow")
{
//Delete the record using WorkflowDefID
string message = string.Empty;
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
message = objWorkFlowBLL.DeleteWorkFlowDef(Convert.ToInt32(e.CommandArgument));
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data Deleted successfully";
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
BindGridWorkFlowDefinition();
clear();
SetUpdateMode(false);
}
else if (e.CommandName == "ClickAddApproved")
{
// ViewState["WorkFlowDefID"] = e.CommandArgument;
GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).NamingContainer;
Literal WorkflowApproverID = (Literal)row.FindControl("litWorkFlowDefID"); //Literal value avaiable in the grid
Literal LitModuleName = (Literal)row.FindControl("LitModuleName");
Literal LitWorkflowName = (Literal)row.FindControl("LitWorkflowName");
// WorkFlowDefIDTextBox.Text = WorkflowApproverID.Text;
ViewState["WorkFlowDefID"] = WorkflowApproverID.Text; //view state value assigned by the help of Literal
WorkFlowDefID(WorkflowApproverID.Text);
ApprovalTable.Visible = true; //Approver Screen Visable
ApproverTab.InnerText = "Approvers For " + LitModuleName.Text + "-" + LitWorkflowName.Text;
#region For load data to Dropen down approval
BindGrid(true, true);
if (ViewState["StatusMode"].ToString() != "ReadOnly")
{
ADDButton.Visible = true;
UpDateButton.Visible = false;
CancelButton.Visible = false;
}
WorkApproverIDTextBox.Text = "0";
WorkDefinationTextBox.Text = "0";
getAllRole();
getLevel();
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
ApproverLevelDropDownList.Enabled = true;
#endregion
BindGrid(true, true); // Calling Approval Bind Grid Data
}
}
/// <summary>
/// To load controls in the grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdProjects_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int ApprovalStatus = 0;
DateTime projStartDate = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "ProjectStartDate"));
if (projStartDate != DateTime.MinValue)
{
((Literal)e.Row.FindControl("litProjectStartDate")).Text = projStartDate.ToString(UtilBO.DateFormat);
}
DateTime projEndDate = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "ProjectEndDate"));
if (projEndDate != DateTime.MinValue)
{
((Literal)e.Row.FindControl("litProjectEndDate")).Text = projEndDate.ToString(UtilBO.DateFormat);
}
LinkButton lnkDataVerification = (LinkButton)e.Row.FindControl("lnkDataVerification");
LinkButton lnkFreeze = (LinkButton)e.Row.FindControl("lnkFreeze");
lnkFreeze.Visible = false;
Literal litProjectID = ((Literal)e.Row.FindControl("litProjectID"));
Literal litDataVerification = ((Literal)e.Row.FindControl("litDataVerification"));
if (litProjectID != null)
{
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowDataVerification;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(litProjectID.Text), ChangeRequestCode);
if (objWorkFlowBO == null)
{
lnkFreeze.Visible = false;
lnkDataVerification.Visible = false;
litDataVerification.Visible = true;
litDataVerification.Text = "Define Approver";
}
else
{
//ApprovalStatus = getApprrequtStatusDataVerification(Convert.ToInt32(litProjectID.Text));
ApprovalStatus = totalcountapproval(Convert.ToInt32(litProjectID.Text));
if (ApprovalStatus == 1)
{
lnkFreeze.Visible = true;
lnkDataVerification.Visible = false;
litDataVerification.Visible = false;
litDataVerification.Text = string.Empty;
//lnkFreeze.Visible = true;
//lnkDataVerification.Visible = false;
//litDataVerification.Visible = false;
}
else if (ApprovalStatus == 2)
{
lnkFreeze.Visible = false;
lnkDataVerification.Visible = true;
litDataVerification.Visible = false;
//litDataVerification.Text = "Approval Pending";
}
else if (ApprovalStatus == 3)
{
lnkFreeze.Visible = false;
lnkDataVerification.Visible = false;
litDataVerification.Visible = false;
}
}
}
//lnkFreeze.Visible = false;
string frozen = DataBinder.Eval(e.Row.DataItem, "Frozen").ToString();
if (frozen == "Y")
{
((LinkButton)e.Row.FindControl("lnkFreeze")).Visible = false;
//((Literal)e.Row.FindControl("litFrozen")).Visible = true;//Under Testing
lnkDataVerification.Visible = false;
litDataVerification.Text = string.Empty;
litDataVerification.Visible = false;
((LinkButton)e.Row.FindControl("lnkFrozen")).Visible = true; //Under Testing
((Panel)e.Row.FindControl("pnlUnfreeze")).Visible = true; //Under Testing
}
else
{
((Panel)e.Row.FindControl("pnlUnfreeze")).Visible = false; //Under Testing
}
int routeCount = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "RouteCount"));
if (routeCount == 0)
{
((System.Web.UI.HtmlControls.HtmlAnchor)e.Row.FindControl("lnkRouteMap")).Visible = false;
}
else
{
((System.Web.UI.HtmlControls.HtmlAnchor)e.Row.FindControl("lnkRouteMap")).Attributes.Add("onclick", string.Format("OpenRouteMap({0});", DataBinder.Eval(e.Row.DataItem, "ProjectID").ToString()));
}
}
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SaveButton_Click(object sender, EventArgs e)
{
int count;
WorkFlowBLL WorkFlowBLLOBJ = new WorkFlowBLL();
if (WORKFLOWDEFINITIONIDTextBox.Text != "0")
{
string message = string.Empty;
string AlertMessage = string.Empty;
string uID = Session["USER_ID"].ToString();
string pID = Session["PROJECT_ID"].ToString();
WorkFlowBO objWorkFlow = new WorkFlowBO();
objWorkFlow.WorkFlowDefID = Convert.ToInt32(WORKFLOWDEFINITIONIDTextBox.Text.ToString());
objWorkFlow.ModuleID = Convert.ToInt32(ModuleDropDownList.SelectedItem.Value.ToString().Trim());
objWorkFlow.WorkflowID = Convert.ToInt32(WorkflowItemDropDownList.SelectedItem.Value.ToString());
objWorkFlow.HigherAuthorityID = Convert.ToInt32(HightAuthDropDownList.SelectedItem.Value.ToString());
objWorkFlow.Trigger = TriggerDropDownList.SelectedItem.Value.ToString();
objWorkFlow.AfterDays = Convert.ToInt32(AfterDropDownList.SelectedItem.Value.ToString());
objWorkFlow.UserID = Convert.ToInt32(uID);
objWorkFlow.ProjectID = Convert.ToInt32(pID);
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
count = WorkFlowBLLobj.EditWorkFlowDef(objWorkFlow);
if (count == -1)
{
BindGridWorkFlowDefinition();
WORKFLOWDEFINITIONIDTextBox.Text = "0";
message = "Data updated successfully.";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
clear();
SetUpdateMode(false);
}
if (count == 1)
{
BindGridWorkFlowDefinition();
WORKFLOWDEFINITIONIDTextBox.Text = "0";
message = "Workflow Item Already Exist";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
clear();
SetUpdateMode(false);
}
}
else
{
try
{
string message = string.Empty;
string AlertMessage = string.Empty;
string uID = Session["USER_ID"].ToString();
string pID = Session["PROJECT_ID"].ToString();
WorkFlowBO objWorkFlow = new WorkFlowBO();
objWorkFlow.ModuleID = Convert.ToInt32(ModuleDropDownList.SelectedItem.Value.ToString().Trim());
objWorkFlow.WorkflowID = Convert.ToInt32(WorkflowItemDropDownList.SelectedItem.Value.ToString());
objWorkFlow.HigherAuthorityID = Convert.ToInt32(HightAuthDropDownList.SelectedItem.Value.ToString());
objWorkFlow.Trigger = TriggerDropDownList.SelectedItem.Value.ToString();
objWorkFlow.AfterDays = Convert.ToInt32(AfterDropDownList.SelectedItem.Value.ToString());
objWorkFlow.UserID = Convert.ToInt32(uID);
objWorkFlow.ProjectID = Convert.ToInt32(pID);
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
count = WorkFlowBLLobj.InsertWorkFlow(objWorkFlow);
if (count == -1)
{
BindGridWorkFlowDefinition();
message = "Data saved successfully.";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
clear();
}
if (count == 1)
{
BindGridWorkFlowDefinition();
message = "Workflow Item Already Exist";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
clear();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
WorkFlowBLLOBJ = null;
}
}
}
/// <summary>
/// method for total count of approval
/// </summary>
/// <param name="ProjectId"></param>
/// <returns></returns>
public int totalcountapproval(int ProjectId)
{
int finalcount = 0;
int approvalcount = 0;
WorkFlowBO objProjectRoute = new WorkFlowBO();
WorkFlowBLL objProjectRouteBLL = new WorkFlowBLL();
WorkFlowList objWorkFlowList = new WorkFlowList();
WorkFlowBO objPrintApprovalWF = null;
WorkFlowList objWorkFlowList_ = null;
string ChangeRequestCode = UtilBO.WorkflowDataVerification;
objProjectRoute.WorkFlowApprover = ChangeRequestCode;
objProjectRoute.Project_Id = ProjectId;
objWorkFlowList = objProjectRouteBLL.getTotalcountapproval(objProjectRoute);
if (objWorkFlowList.Count > 0)
{
int totalapprovalCount = Convert.ToInt32(objProjectRoute.CountApproval);
for (int i = 0; i < objWorkFlowList.Count; i++)
{
//if (Session["HH_ID"] != null)
//{
// objProjectRoute.HHID = Convert.ToInt32(Session["HH_ID"].ToString());
//}
//else
//{
// objProjectRoute.HHID = 0;
//}
objProjectRoute.HHID = 0;
//objProjectRoute.HHID = householdID;
objProjectRoute.PageCode = UtilBO.WorkflowDataVerification; // objHouseHold.PageCode = "DATAV";
objProjectRoute.WorkflowCode = UtilBO.WorkflowDataVerification;
objProjectRoute.LEVEL = objWorkFlowList[i].CountApproval;
objPrintApprovalWF = objProjectRouteBLL.ApprovalStatuscheck(objProjectRoute);
//addtional list
objWorkFlowList_ = objProjectRouteBLL.ApprovalStatuschecklist(objProjectRoute);
if (objPrintApprovalWF != null)
{
if (objWorkFlowList[i].CountApproval == objPrintApprovalWF.LEVEL)
{
if (objPrintApprovalWF.ApprovalstatusID == 1)
{
finalcount = 1;
break;
}
else if (objPrintApprovalWF.ApprovalstatusID == 2)
{
finalcount = 2;
approvalcount = 0;
break;
}
else if (objPrintApprovalWF.ApprovalstatusID == 3)
{
finalcount = 3;
approvalcount = 0;
break;
}
}
else
{
//i + 1; addtionl Code
if (objWorkFlowList[i].CountApproval == objWorkFlowList_[i].LEVEL)
{
if (objWorkFlowList_[i].ApprovalstatusID == 3)
{
finalcount = 3;
break;
}
else
{
approvalcount = 0;
}
}
}
}
if (objWorkFlowList.Count == approvalcount)
{
finalcount = 1;
}
else
{
finalcount = 0;
}
}
}
return(finalcount);
}
