protected void gvIncorrectData_RowDataBound(object sender, GridViewRowEventArgs e) { if (gvIncorrectData.EditIndex == e.Row.RowIndex) { if (e.Row.RowType == DataControlRowType.DataRow) { Saplin.Controls.DropDownCheckBoxes ddlMultiClient = (Saplin.Controls.DropDownCheckBoxes)e.Row.FindControl("ddlMultiple"); //Saplin.Controls.DropDownCheckBoxes ddlMultiClient = SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@emp", ddlEmp.SelectedItem.Text), new SqlParameter("@team", ddlEmp.SelectedValue) }; ds = new DataSet(); if (rbUser.Checked == true) { sQuery = "select * from RTM_Client_List, RTM_User_List where CL_TeamId= UL_Team_Id and UL_User_Name=@emp and CL_Status=1 and CL_ClientName <> 'Other' order by CL_ClientName"; } else if (rbTeam.Checked == true) { sQuery = "select * from RTM_Client_List where CL_TeamId= @team and CL_Status=1 and CL_ClientName <> 'Other' order by CL_ClientName"; } ds = objDB.DSExecuteParamerizedSelectCommand(sQuery, CommandType.Text, parameters, "multiclient"); if (ds.Tables["multiclient"].Rows.Count > 0) { ddlMultiClient.DataSource = ds.Tables["multiclient"]; ddlMultiClient.DataTextField = "CL_ClientName"; ddlMultiClient.DataValueField = "CL_ID"; ddlMultiClient.DataBind(); } } } }
protected void gvIncorrectData_RowUpdating(object sender, GridViewUpdateEventArgs e) { int checkedCount = 0; try { int id = Convert.ToInt32(gvIncorrectData.DataKeys[e.RowIndex].Values["R_ID"].ToString()); Saplin.Controls.DropDownCheckBoxes ddlMultiSelect = (Saplin.Controls.DropDownCheckBoxes)gvIncorrectData.Rows[e.RowIndex].FindControl("ddlMultiple"); foreach (System.Web.UI.WebControls.ListItem item in ddlMultiSelect.Items) { if (item.Selected) { checkedCount = checkedCount + 1; } } if (checkedCount == 0) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Select Client", "alert('Please select the clients')", true); //lblError.Text = "Please select the clients"; //lblError.ForeColor = System.Drawing.Color.Red; ddlMultiSelect.Focus(); return; } if (checkedCount == 1) { foreach (System.Web.UI.WebControls.ListItem item in ddlMultiSelect.Items) { if (item.Selected) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@client", item.Value), new SqlParameter("@id", id) }; sQuery = "Update RTM_Records SET R_Client= @client where R_ID=@id"; bool result = objDB.ExecuteNonQuery(sQuery, CommandType.Text, parameters); } } } else { ds = getRecord(id); if (ds.Tables["Irecord"].Rows.Count > 0) { int TID = Convert.ToInt32(ds.Tables["Irecord"].Rows[0]["R_TeamId"]); string EID = ds.Tables["Irecord"].Rows[0]["R_Employee_Id"].ToString(); string Uname = ds.Tables["Irecord"].Rows[0]["R_User_Name"].ToString(); int taskId = Convert.ToInt32(ds.Tables["Irecord"].Rows[0]["R_Task"]); int subTaskId = Convert.ToInt32(ds.Tables["Irecord"].Rows[0]["R_SubTask"]); string comments = ds.Tables["Irecord"].Rows[0]["R_Comments"].ToString(); string dur = ds.Tables["Irecord"].Rows[0]["R_Duration"].ToString(); string startTime = ds.Tables["Irecord"].Rows[0]["R_Start_Date_Time"].ToString(); string createdOn = ds.Tables["Irecord"].Rows[0]["R_CreatedOn"].ToString(); if (dur != "") { double timeSeconds = TimeSpan.Parse(dur).TotalSeconds; timeSeconds = timeSeconds / checkedCount; // string splitTime = ConvertToTime(timeSeconds); var hms = TimeSpan.FromSeconds(timeSeconds); var h = hms.Hours.ToString("00"); var m = hms.Minutes.ToString("00"); var s = hms.Seconds.ToString("00"); string splitTime = h + ":" + m + ":" + s; foreach (System.Web.UI.WebControls.ListItem item in ddlMultiSelect.Items) { if (item.Selected) { SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@teamId", TID), new SqlParameter("@empId", EID), new SqlParameter("@userName", Uname), new SqlParameter("@client", item.Value), new SqlParameter("@task", taskId), new SqlParameter("@subtask", subTaskId), new SqlParameter("@comments", comments), new SqlParameter("@duration", splitTime), new SqlParameter("@startTime", startTime), new SqlParameter("@createdOn", createdOn), new SqlParameter("@status", "Completed") }; sQuery = "insert into RTM_Records(R_TeamId, R_Employee_Id, R_User_Name, R_Client, R_Task, R_SubTask, R_Comments, R_Duration, R_Start_Date_Time, R_CreatedOn, R_Status) values (@teamId, @empId, @userName, @client, @task, @subtask, @comments, @duration, @startTime, @createdOn,@status )"; bool result = objDB.ExecuteNonQuery(sQuery, CommandType.Text, parameters); } } SqlParameter[] parameters1 = new SqlParameter[] { new SqlParameter("@id", id) }; sQuery = "Delete from RTM_Records where R_ID =@id"; bool result1 = objDB.ExecuteNonQuery(sQuery, CommandType.Text, parameters1); } } } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Incorrect Record", "alert('Record Corrected Successfully')", true); gvIncorrectData.EditIndex = -1; BindIncorrectGrid(); } catch (Exception) { } }