protected void TxtDate_TextChanged(object sender, EventArgs e) { try { if (TxtDate.Text.Length != 0) { StrSql = new StringBuilder(); StrSql.Length = 0; StrSql.AppendLine("Select D.Working_Date"); StrSql.AppendLine("From DailyAttendance D"); StrSql.AppendLine("Where D.EmpId=" + int.Parse(ddlEmployee.SelectedValue)); StrSql.AppendLine("And D.Working_Date='" + ValueConvert.ConvertDate(TxtDate.Text.ToString()) + "'"); dtTemp = new DataTable(); dtTemp = SqlFunc.ExecuteDataTable(StrSql.ToString()); if (dtTemp.Rows.Count != 0) { LblMsg.Text = "Attendance Entry Allready Done For " + TxtDate.Text.ToString() + "."; TxtDate.Text = ""; TxtDays.Text = ""; TxtMonth.Text = ""; TxtDate.Focus(); return; } LblMsg.Text = ""; GetDayMonth(); TxtInTime.Focus(); } } catch (Exception ex) { Response.Write(ex.ToString()); } }
//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); } }