private void getAllDetails()
{
con.Open();
SqlDataAdapter adapter = new SqlDataAdapter("SELECT * FROM AssignActiveHrs WHERE ID ='" + this.ID + "'", con);
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
string days = dataTable.Rows[0]["Working_Days"].ToString();
string[] dayss = days.Split(',');
foreach (string d in dayss)
{
foreach (Object l in WeekPanel.Items)
{
if (d.Equals(l.ToString()))
{
// MessageBox.Show(l.ToString());
switch (l.ToString())
{
case "Monday":
WeekPanel.SetItemChecked(0, true);
break;
case "Tuesday":
WeekPanel.SetItemChecked(1, true);
break;
case "Wednesday":
WeekPanel.SetItemChecked(2, true);
break;
case "Thursday":
WeekPanel.SetItemChecked(3, true);
break;
case "Friday":
WeekPanel.SetItemChecked(4, true);
break;
case "Saturday":
WeekPanel.SetItemChecked(5, true);
break;
case "Sunday":
WeekPanel.SetItemChecked(6, true);
break;
default:
break;
}
break;
}
}
}
}
con.Close();
}
private void ResetAssignActiveHrsFormContrils()
{
ID = 0;
cmbEmpName.ResetText();
textRank.Clear();
numDays.Value = 0;
// WeekPanel.ClearSelected();
numHrs.Value = 0;
numMin.Value = 0;
for (int i = 0; i < WeekPanel.Items.Count; i++)
{
WeekPanel.SetItemChecked(i, false);
}
cmbEmpName.Focus();
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (ID > 0)
{
SqlCommand cmd = new SqlCommand("UPDATE AssignActiveHrs SET EmployeeName_A=@EmployeeName_A, Rank_A = @Rank_A, Num_Days = @Num_Days, Working_Days = @Working_Days, Active_Hrs = @Active_Hrs, Active_mins = @Active_mins WHERE ID = @ID", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@EmployeeName_A", cmbEmpName.Text.ToString());
cmd.Parameters.AddWithValue("@Rank_A", textRank.Text);
cmd.Parameters.AddWithValue("@Num_Days", numDays.Value);
string s = string.Empty;
foreach (object li in WeekPanel.CheckedItems)
{
s += li + "-";
}
cmd.Parameters.AddWithValue("@Working_Days", s);
cmd.Parameters.AddWithValue("@Active_Hrs", numHrs.Value);
cmd.Parameters.AddWithValue("@Active_mins", numMin.Value);
cmd.Parameters.AddWithValue("@ID", this.ID);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("Updated successfully...!", "Updated", MessageBoxButtons.OK, MessageBoxIcon.Information);
GetAssignActiveHrsRecord();
ResetAssignActiveHrsFormContrils();
for (int i = 0; i < WeekPanel.Items.Count; i++)
{
WeekPanel.SetItemChecked(i, false);
}
}
else
{
MessageBox.Show("UnSuccessfull", "Select?", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (IsValid())
{
SqlCommand cmd = new SqlCommand("INSERT INTO AssignActiveHrs VALUES(@EmployeeName_A, @Rank_A, @Num_Days, @Working_Days, @Active_Hrs, @Active_mins)", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@EmployeeName_A", cmbEmpName.Text.ToString());
cmd.Parameters.AddWithValue("@Rank_A", textRank.Text);
cmd.Parameters.AddWithValue("@Num_Days", numDays.Value);
string s = string.Empty;
foreach (object li in WeekPanel.CheckedItems)
{
s += li + ",";
}
cmd.Parameters.AddWithValue("@Working_Days", s);
cmd.Parameters.AddWithValue("@Active_Hrs", numHrs.Value);
cmd.Parameters.AddWithValue("@Active_mins", numMin.Value);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
MessageBox.Show("New record is saved successfully", "Saved", MessageBoxButtons.OK, MessageBoxIcon.Information);
for (int i = 0; i < WeekPanel.Items.Count; i++)
{
WeekPanel.SetItemChecked(i, false);
}
GetAssignActiveHrsRecord();
ResetAssignActiveHrsFormContrils();
}
}
