protected void Statusgrdvw_RowUpdating(object sender, GridViewUpdateEventArgs e) { string name, desc, id; int StatusId = 0; ChangeStatus_mst ObjStatus1 = new ChangeStatus_mst(); name = ((TextBox)Statusgrdvw.Rows[e.RowIndex].Cells[1].Controls[0].FindControl("txtStatusName")).Text; desc = ((TextBox)Statusgrdvw.Rows[e.RowIndex].Cells[2].Controls[0].FindControl("txtStatusdesc")).Text; id = Convert.ToString(Statusgrdvw.Rows[e.RowIndex].Cells[0].Text); StatusId = Convert.ToInt16(id); statusnamecount = ObjStatus1.Get_By_StatusName(name); ObjStatus1 = ObjStatus1.Get_By_id(StatusId); if ((statusnamecount == 0) && (name != "")) { ObjStatus1.Statusname = name; ObjStatus1.ChangeStatusid = StatusId; ObjStatus1.Description = desc; ObjStatus1.Update(); Statusgrdvw.EditIndex = -1; BindGrid(); lblerrmsg.Text = Resources.MessageResource.errupdate.ToString(); } else if (name == "") { BindGrid(); lblerrmsg.Text = "Status name should not be empty"; } else if (ObjStatus1.Statusname == name) { ObjStatus1.ChangeStatusid = StatusId; ObjStatus1.Statusname = name; ObjStatus1.Description = desc; ObjStatus1.Update(); Statusgrdvw.EditIndex = -1; BindGrid(); lblerrmsg.Text = Resources.MessageResource.errupdate.ToString(); } else { BindGrid(); lblerrmsg.Text = Resources.MessageResource.errStatusExist.ToString(); } Statusgrdvw.EditIndex = -1; }
protected void btnStatusAdd_Click(object sender, EventArgs e) { statusnamecount = ObjStatus.Get_By_StatusName(txtStatusName.Text.ToString()); if (statusnamecount == 0) { ObjStatus.Description = txtStatusDesc.Text.ToString(); ObjStatus.Statusname = txtStatusName.Text.ToString(); ObjStatus.Insert(); BindGrid(); lblerrmsg.Text = Resources.MessageResource.erradd.ToString(); } else { lblerrmsg.Text = Resources.MessageResource.errStatusExist.ToString(); } txtStatusName.Text = ""; txtStatusDesc.Text = ""; }
protected void BindGridForAllParameter() { #region Declaration of localvariable and table Variable int filterId; DataTable dtTable = new DataTable(); dtTable = CreateDataTable(); string userName = ""; int varTechnicianId = 0; if (drpTechnician.SelectedValue != "") { varTechnicianId = Convert.ToInt16(drpTechnician.SelectedValue); } string varSortParameter = ""; varSortParameter = drpSort.SelectedValue; if (varSortParameter == "0") { varSortParameter = "createdatetime"; } #endregion #region Get Current User and his Role MembershipUser User = Membership.GetUser(); string varUserRole = ""; string varRoleTechnician = ""; if (User != null) { userName = User.UserName.ToString(); string[] arrUserRole = Roles.GetRolesForUser(); varUserRole = arrUserRole[0].ToString(); varRoleTechnician = Resources.MessageResource.strTechnicianRole.ToString(); } #endregion #region Get User object by Calling Function Get_UserLogin_By_UserName() via passing parameter username and organizationid objOrganization = objOrganization.Get_Organization(); objUser = objUser.Get_UserLogin_By_UserName(userName, objOrganization.Orgid); #endregion #region if UserExist if (objUser.Userid != 0) { ViewState["Userid"] = objUser.Userid; string fromdate = null; string todate = null; if (ViewState["fromdate"] != null) { fromdate = ViewState["fromdate"].ToString(); } if (ViewState["todate"] != null) { todate = ViewState["todate"].ToString(); } if (fromdate == "") { fromdate = null; } if (todate == "") { todate = null; } #region Declare Local Variables and Collection of Incident_mst Type string Status; // int siteid; #endregion #region Get the Siteid and Filter Parameter //siteid = obj.Siteid; filterId = Convert.ToInt16(drpFilter.SelectedValue); #endregion #region If Role of User is Technician if (varUserRole == varRoleTechnician) { lblTechnician.Visible = false; drpTechnician.Visible = false; //lblTechnician1.Visible = false; //drpTechnician1.Visible = false; //btnAssigned.Visible = false; #region If Filter Variable is All if (filterId == 0) { // col = objIncident.Get_All_By_Siteid_Technicianid(siteid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Requested else if (filterId == 1) { Status = Resources.MessageResource.strChangestatusrequested.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Approval else if (filterId == 2) { Status = Resources.MessageResource.StrApproval.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Approval else if (filterId == 3) { Status = Resources.MessageResource.StrApproved.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Rejected else if (filterId == 4) { Status = Resources.MessageResource.StrRejected.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Planning else if (filterId == 5) { Status = Resources.MessageResource.StrPlanning.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Testing else if (filterId == 6) { Status = Resources.MessageResource.StrTesting.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Release else if (filterId == 7) { Status = Resources.MessageResource.StrRelease.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Implemented else if (filterId == 8) { Status = Resources.MessageResource.StrImplemented.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Completed else if (filterId == 9) { Status = Resources.MessageResource.StrCompleted.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid_technicianid(statusid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion } #endregion #region If User Role is other then technician else { #region If Filter Variable is All if (filterId == 0) { // col = objIncident.Get_All_By_Siteid_Technicianid(siteid, objUser.Userid, fromdate, todate, varSortParameter); } #endregion #region If Filter Variable is Requested else if (filterId == 1) { Status = Resources.MessageResource.strChangestatusrequested.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Approval else if (filterId == 2) { Status = Resources.MessageResource.StrApproval.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Approval else if (filterId == 3) { Status = Resources.MessageResource.StrApproved.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Rejected else if (filterId == 4) { Status = Resources.MessageResource.StrRejected.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Planning else if (filterId == 5) { Status = Resources.MessageResource.StrPlanning.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Testing else if (filterId == 6) { Status = Resources.MessageResource.StrTesting.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Release else if (filterId == 7) { Status = Resources.MessageResource.StrRelease.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Implemented else if (filterId == 8) { Status = Resources.MessageResource.StrImplemented.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion #region If Filter Variable is Completed else if (filterId == 9) { Status = Resources.MessageResource.StrCompleted.ToString(); int statusid; statusid = ObjChangeStatus.Get_By_StatusName(Status); col = ObjChange.Get_All_By_Statusid(statusid, fromdate, todate, varTechnicianId, varSortParameter); } #endregion } #endregion } #endregion #region Fetch Each object of type Change_mst from Collection Change_mst foreach (Change_mst obj in col) { #region Create Table row and assign value to it DataRow row; row = dtTable.NewRow(); row["Changeid"] = Convert.ToString(obj.Changeid); row["title"] = obj.Title; row["Requestedby"] = Convert.ToString(obj.Requestedby); row["CreatedByid"] = Convert.ToString(obj.CreatedByID); row["Technician"] = Convert.ToString(obj.Technician); row["Statusid"] = obj.Statusid; row["Priority"] = obj.Priority; row["Createdtime"] = obj.Createdtime; dtTable.Rows.Add(row); #endregion } //} #endregion #region Bind Grid from datasource dtTable grdvwChange.DataSource = dtTable; grdvwChange.DataBind(); #endregion }