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