//protected void GridInOut_SelectedIndexChanged(object sender, EventArgs e)
//{
// try
// {
// HidFldId.Value = GridInOut.DataKeys[GridInOut.SelectedRow.RowIndex].Value.ToString();
// StrSql = new StringBuilder();
// StrSql.Length = 0;
// StrSql = new StringBuilder();
// StrSql.Length = 0;
// StrSql.AppendLine("Select D.Id,D.EmpId");
// StrSql.AppendLine(",D.OffiFTime,D.OffiTTime,D.OffiHours");
// StrSql.AppendLine(",Convert(Varchar(10),D.Working_Date,103) As Working_Date,D.Working_Days,D.Working_Month");
// StrSql.AppendLine(",D.InTime,D.OutTime,D.TotWork_Hours");
// StrSql.AppendLine(",D.OverTime,D.LessTime");
// StrSql.AppendLine(",D.Reason,D.Remark");
// StrSql.AppendLine("From DailyAttendance D");
// StrSql.AppendLine("Where D.Id=" + int.Parse(HidFldId.Value));
// dtTemp = new DataTable();
// dtTemp = SqlFunc.ExecuteDataTable(StrSql.ToString());
// if (dtTemp.Rows.Count == 0)
// {
// LblMsg.Text = "Data not found";
// return;
// }
// ddlEmployee.Items.Clear();
// ddlEmployee.DataSource = BLayer.FillEmp("");
// ddlEmployee.DataValueField = "EmpId";
// ddlEmployee.DataTextField = "EmpName";
// ddlEmployee.DataBind();
// ddlEmployee.Items.Insert(0, new ListItem("--Select Employee--", "0"));
// if (dtTemp.Rows[0]["EmpId"].ToString() != "")
// {
// ddlEmployee.SelectedValue = dtTemp.Rows[0]["EmpId"].ToString();
// }
// TxtOffFTime.Text = dtTemp.Rows[0]["OffiFTime"].ToString();
// TxtOffTTime.Text = dtTemp.Rows[0]["OffiTTime"].ToString();
// TxtOffHours.Text = dtTemp.Rows[0]["OffiHours"].ToString();
// TxtDate.Text = dtTemp.Rows[0]["Working_Date"].ToString();
// TxtDays.Text = dtTemp.Rows[0]["Working_Days"].ToString();
// TxtMonth.Text = dtTemp.Rows[0]["Working_Month"].ToString();
// TxtInTime.Text = dtTemp.Rows[0]["InTime"].ToString();
// TxtOutTime.Text = dtTemp.Rows[0]["OutTime"].ToString();
// TxtTotWrkHours.Text = dtTemp.Rows[0]["TotWork_Hours"].ToString();
// TxtOverTime.Text = dtTemp.Rows[0]["OverTime"].ToString();
// TxtLessTime.Text = dtTemp.Rows[0]["LessTime"].ToString();
// TxtReason.Text = dtTemp.Rows[0]["Reason"].ToString();
// TxtRemark.Text = dtTemp.Rows[0]["Remark"].ToString();
// ddlEmployee.Enabled = false;
// // Move to Edit Tab
// MyMenu.Items[0].ImageUrl = "~/Images/ViewDisable.jpg";
// MyMenu.Items[1].ImageUrl = "~/Images/NewOrEditEnable.jpg";
// MyMenu.Items[1].Selected = true;
// MyMultiView.ActiveViewIndex = 1;
// }
// catch (Exception ex)
// {
// Response.Write(ex.ToString());
// }
//}
protected void BtnSave_Click(object sender, EventArgs e)
{
try
{
if (ddlEmployee.SelectedValue == "0")
{
//LblMsg.Text = "Employee Name Is Blank, Enter Valid Name....";
ddlEmployee.Focus();
return;
}
if (TxtDate.Text.Length == 0)
{
//LblMsg.Text = "Date Is Blank, Enter Valid Date....";
TxtDate.Focus();
return;
}
if (TxtInTime.Text.Length == 0)
{
//LblMsg.Text = "In Time Is Blank, Enter Valid Time....";
TxtInTime.Focus();
return;
}
string[] TotWrkHours = TxtTotWrkHours.Text.Split('.');
int WrkH = ValueConvert.ValInt16(TotWrkHours[0].ToString());
if (WrkH < 5 && TxtReason.Text.Length == 0)
{
LblMsg.Text = "Give Valid Reason, Because Working Hours Is Less Then 5.00...";
TxtReason.Focus();
return;
}
LblMsg.Text = "";
StrSql = new StringBuilder();
StrSql.Length = 0;
if (HidFldId.Value.Length == 0)
{
StrSql.AppendLine("Insert Into DailyAttendance");
StrSql.AppendLine("(EmpId");
StrSql.AppendLine(",OffiFTime");
StrSql.AppendLine(",OffiTTime");
StrSql.AppendLine(",OffiHours");
StrSql.AppendLine(",Working_Date");
StrSql.AppendLine(",Working_Days");
StrSql.AppendLine(",Working_Month");
StrSql.AppendLine(",InTime");
StrSql.AppendLine(",OutTime");
StrSql.AppendLine(",TotWork_Hours");
StrSql.AppendLine(",OverTime");
StrSql.AppendLine(",LessTime");
StrSql.AppendLine(",Reason");
StrSql.AppendLine(",Remark");
StrSql.AppendLine(",Entry_Date");
StrSql.AppendLine(",Entry_Time");
StrSql.AppendLine(",Entry_UID");
StrSql.AppendLine(",UPDFLAG");
StrSql.AppendLine(")");
StrSql.AppendLine("Values");
StrSql.AppendLine("(@EmpId");
StrSql.AppendLine(",@OffiFTime");
StrSql.AppendLine(",@OffiTTime");
StrSql.AppendLine(",@OffiHours");
StrSql.AppendLine(",@Working_Date");
StrSql.AppendLine(",@Working_Days");
StrSql.AppendLine(",@Working_Month");
StrSql.AppendLine(",@InTime");
StrSql.AppendLine(",@OutTime");
StrSql.AppendLine(",@TotWork_Hours");
StrSql.AppendLine(",@OverTime");
StrSql.AppendLine(",@LessTime");
StrSql.AppendLine(",@Reason");
StrSql.AppendLine(",@Remark");
StrSql.AppendLine(",GetDate()");
StrSql.AppendLine(",Convert(VarChar,GetDate(),108)");
StrSql.AppendLine(",@Entry_UID");
StrSql.AppendLine(",0");
StrSql.AppendLine(")");
}
else
{
StrSql.AppendLine("Update DailyAttendance");
StrSql.AppendLine("Set OffiFTime=@OffiFTime");
StrSql.AppendLine(",OffiTTime=@OffiTTime");
StrSql.AppendLine(",OffiHours=@OffiHours");
StrSql.AppendLine(",Working_Date=@Working_Date");
StrSql.AppendLine(",Working_Days=@Working_Days");
StrSql.AppendLine(",Working_Month=@Working_Month");
StrSql.AppendLine(",InTime=@InTime");
StrSql.AppendLine(",OutTime=@OutTime");
StrSql.AppendLine(",TotWork_Hours=@TotWork_Hours");
StrSql.AppendLine(",OverTime=@OverTime");
StrSql.AppendLine(",LessTime=@LessTime");
StrSql.AppendLine(",Reason=@Reason");
StrSql.AppendLine(",Remark=@Remark");
StrSql.AppendLine(",MEntry_Date=GetDate(),MEntry_Time=Convert(Varchar,GetDate(),108)");
StrSql.AppendLine(",MEntry_UID=@Entry_UID");
StrSql.AppendLine(",UPDFLAG=IsNull(UPDFlag,0)+1");
StrSql.AppendLine("Where Id=@Id And EmpId=@EmpId");
}
Cmd = new SqlCommand(StrSql.ToString(), SqlFunc.gConn);
if (ddlEmployee.SelectedValue != "0")
{
Cmd.Parameters.AddWithValue("@EmpId", ddlEmployee.SelectedValue);
}
else
{
Cmd.Parameters.AddWithValue("@EmpId", DBNull.Value);
}
Cmd.Parameters.AddWithValue("@OffiFTime", TxtOffFTime.Text);
Cmd.Parameters.AddWithValue("@OffiTTime", TxtOffTTime.Text);
Cmd.Parameters.AddWithValue("@OffiHours", TxtOffHours.Text);
if (TxtDate.Text.Length != 0)
{
Cmd.Parameters.AddWithValue("@Working_Date", ValueConvert.ConvertDate(TxtDate.Text));
}
else
{
Cmd.Parameters.AddWithValue("@Working_Date", DBNull.Value);
}
Cmd.Parameters.AddWithValue("@Working_Days", TxtDays.Text);
Cmd.Parameters.AddWithValue("@Working_Month", TxtMonth.Text);
Cmd.Parameters.AddWithValue("@InTime", TxtInTime.Text);
Cmd.Parameters.AddWithValue("@OutTime", TxtOutTime.Text);
Cmd.Parameters.AddWithValue("@TotWork_Hours", TxtTotWrkHours.Text);
Cmd.Parameters.AddWithValue("@OverTime", TxtOverTime.Text);
Cmd.Parameters.AddWithValue("@LessTime", TxtLessTime.Text);
Cmd.Parameters.AddWithValue("@Reason", TxtReason.Text);
Cmd.Parameters.AddWithValue("@Remark", TxtRemark.Text);
Cmd.Parameters.AddWithValue("@Entry_UID", HidFldUID.Value.ToString());
if (HidFldId.Value.Length == 0)
{
SqlFunc.ExecuteNonQuery(Cmd);
LblMsg.Text = "Entry added successfully";
}
else
{
Cmd.Parameters.AddWithValue("@ID", HidFldId.Value.ToString());
SqlFunc.ExecuteNonQuery(Cmd);
LblMsg.Text = "Entry updated successfully";
}
FillGrid();
ClearAll();
//// Move to View Tab
//MyMenu.Items[0].Selected = true;
//MyMenu.Items[0].ImageUrl = "~/Images/ViewEnable.jpg";
//MyMultiView.ActiveViewIndex = 0;
//MyMenu.Items[1].ImageUrl = "~/Images/NewOrEditDisable.jpg";
ddlEmployee.Focus();
}
catch (Exception ex)
{
Response.Write(ex);
}
}
private void WdwExpenseLoanEntry_Loaded(object sender, RoutedEventArgs e)
{
TxtReason.Focus();
}
