/// <summary>
/// Function to Update values in DailyAttendanceMaster Table
/// </summary>
/// <param name="dailyattendancemasterinfo"></param>
public void DailyAttendanceMasterEdit(DailyAttendanceMasterInfo dailyattendancemasterinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("DailyAttendanceMasterEdit", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@dailyAttendanceMasterId", SqlDbType.Decimal);
sprmparam.Value = dailyattendancemasterinfo.DailyAttendanceMasterId;
sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime);
sprmparam.Value = dailyattendancemasterinfo.Date;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = dailyattendancemasterinfo.Narration;
sprmparam = sccmd.Parameters.Add("@extraDate", SqlDbType.DateTime);
sprmparam.Value = dailyattendancemasterinfo.ExtraDate;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = dailyattendancemasterinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = dailyattendancemasterinfo.Extra2;
sccmd.ExecuteNonQuery();
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
private DataTable GetAttendenceFromDB(string strDate)
{
DataTable dtblAttendance = new DataTable();
try
{
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
infoDailyAttendanceMaster.Date = Convert.ToDateTime(strDate);
dtblAttendance = spDailyAttendanceDetails.DailyAttendanceDetailsSearchGridFill(strDate);
for (int i = 0; i < dtblAttendance.Rows.Count; i++)
{
string status = dtblAttendance.Rows[i]["status"].ToString();
if (status == string.Empty)
{
dtblAttendance.Rows[i]["status"] = "Present";
}
}
}
catch (Exception ex)
{
//MessageBox.Show("A1" + ex.Message, "Masterfine", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(dtblAttendance);
}
public bool SaveFunction(string date, string tableData)
{
try
{
List <Dictionary <string, object> > items = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(tableData);
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
infoDailyAttendanceMaster.Date = Convert.ToDateTime(date);
infoDailyAttendanceMaster.Narration = string.Empty;
infoDailyAttendanceMaster.Extra1 = string.Empty;
infoDailyAttendanceMaster.Extra2 = string.Empty;
int inrowcount = items.Count;
var decMasterIdForEdit = spDailyAttendanceMaster.DailyAttendanceAddToMaster(infoDailyAttendanceMaster); // calling @@identity
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
for (int i = 0; i < inrowcount; i++)
{
string employeeId = items[i]["employeeId"].ToString() ?? string.Empty;
string status = items[i]["status"].ToString() ?? string.Empty;
string narration = items[i]["narration"].ToString() ?? string.Empty;
narration = narration.Replace("\n", "\\n");
if (employeeId != null && employeeId != string.Empty)
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(employeeId);
}
if (status != null && status != string.Empty)
{
infoDailyAttendanceDetails.Status = status;
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (narration != null && narration != "")
{
infoDailyAttendanceDetails.Narration = narration;
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
spDailyAttendanceDetails.DailyAttendanceDetailsAddUsingMasterId(infoDailyAttendanceDetails);
}
}
catch (Exception ex)
{
return(false);
}
return(true);
}
public void DailyAttendanceEditMaster(DailyAttendanceMasterInfo dailyattendancemasterinfo)
{
try
{
SpDailyAttendanceMaster.DailyAttendanceEditMaster(dailyattendancemasterinfo);
}
catch (Exception ex)
{
MessageBox.Show("A9" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
string strDate = txtCompanyCurrentdate.Text;
if (spDailyAttendanceMaster.DailyAttendanceMasterMasterIdSearch(strDate))
{
DataTable dtblAttendance = new DataTable();
infoDailyAttendanceMaster.Date = Convert.ToDateTime(txtCompanyCurrentdate.Text.ToString());
dtblAttendance = spDailyAttendanceDetails.DailyAttendanceDetailsSearchGridFill(txtCompanyCurrentdate.Text.ToString());
dgvAttendance.DataSource = dtblAttendance;
btnDelete.Enabled = true;
btnSave.Text = "Update";
int inRowCount = dgvAttendance.RowCount;
string strMasterNarration = string.Empty;
for (int i = 0; i < inRowCount; i++)
{
if (dgvAttendance.Rows[i].Cells["MasterNarration"].Value.ToString() != "")
{
strMasterNarration = dgvAttendance.Rows[i].Cells["MasterNarration"].Value.ToString();
}
}
txtNarrationInMaster.Text = strMasterNarration;
}
else
{
DataTable dtblAttendance = new DataTable();
dtblAttendance = spDailyAttendanceDetails.DailyAttendanceDetailsSearchGridFill(txtCompanyCurrentdate.Text.ToString());
dgvAttendance.DataSource = dtblAttendance;
btnDelete.Enabled = false;
btnSave.Text = "Save";
int inRowCount = dgvAttendance.RowCount;
string strMasterNarration = string.Empty;
for (int i = 0; i < inRowCount; i++)
{
if (dgvAttendance.Rows[i].Cells["MasterNarration"].Value.ToString() != null)
{
strMasterNarration = dgvAttendance.Rows[i].Cells["MasterNarration"].Value.ToString();
}
}
txtNarrationInMaster.Text = strMasterNarration;
}
}
catch (Exception ex)
{
MessageBox.Show("A1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public decimal DailyAttendanceAddToMaster(DailyAttendanceMasterInfo dailyattendancemasterinfo)
{
decimal incount = 0;
try
{
incount = SpDailyAttendanceMaster.DailyAttendanceAddToMaster(dailyattendancemasterinfo);
}
catch (Exception ex)
{
MessageBox.Show("A8" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
return(incount);
}
/// <summary>
/// Function to add Daily Attendance Add To its Master table
/// </summary>
/// <param name="dailyattendancemasterinfo"></param>
/// <returns></returns>
public decimal DailyAttendanceAddToMaster(DailyAttendanceMasterInfo dailyattendancemasterinfo)
{
decimal incount = 0;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("DailyAttendanceAddToMaster", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@date", SqlDbType.DateTime);
sprmparam.Value = dailyattendancemasterinfo.Date;
sprmparam = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam.Value = dailyattendancemasterinfo.Narration;
sprmparam = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam.Value = dailyattendancemasterinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = dailyattendancemasterinfo.Extra2;
Object obj = sccmd.ExecuteScalar();
if (obj != null)
{
incount = decimal.Parse(obj.ToString());
}
{
}
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
return(incount);
}
/// <summary>
/// Function to get particular values from DailyAttendanceMaster Table based on the parameter
/// </summary>
/// <param name="dailyAttendanceMasterId"></param>
/// <returns></returns>
public DailyAttendanceMasterInfo DailyAttendanceMasterView(decimal dailyAttendanceMasterId)
{
DailyAttendanceMasterInfo dailyattendancemasterinfo = new DailyAttendanceMasterInfo();
SqlDataReader sdrreader = null;
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("DailyAttendanceMasterView", sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam = new SqlParameter();
sprmparam = sccmd.Parameters.Add("@dailyAttendanceMasterId", SqlDbType.Decimal);
sprmparam.Value = dailyAttendanceMasterId;
sdrreader = sccmd.ExecuteReader();
while (sdrreader.Read())
{
dailyattendancemasterinfo.DailyAttendanceMasterId = decimal.Parse(sdrreader[0].ToString());
dailyattendancemasterinfo.Date = DateTime.Parse(sdrreader[1].ToString());
dailyattendancemasterinfo.Narration = sdrreader[2].ToString();
dailyattendancemasterinfo.ExtraDate = DateTime.Parse(sdrreader[3].ToString());
dailyattendancemasterinfo.Extra1 = sdrreader[4].ToString();
dailyattendancemasterinfo.Extra2 = sdrreader[5].ToString();
}
}
catch (Exception ex)
{
//MessageBox.Show(ex.ToString());
}
finally
{
sdrreader.Close();
sqlcon.Close();
}
return(dailyattendancemasterinfo);
}
public void DailyAttendanceEditMaster(DailyAttendanceMasterInfo dailyattendancemasterinfo)
{
try
{
if (base.sqlcon.State == ConnectionState.Closed)
{
base.sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("DailyAttendanceEditMaster", base.sqlcon);
sccmd.CommandType = CommandType.StoredProcedure;
SqlParameter sprmparam6 = new SqlParameter();
sprmparam6 = sccmd.Parameters.Add("@dailyAttendanceMasterId", SqlDbType.Decimal);
sprmparam6.Value = dailyattendancemasterinfo.DailyAttendanceMasterId;
sprmparam6 = sccmd.Parameters.Add("@date", SqlDbType.DateTime);
sprmparam6.Value = dailyattendancemasterinfo.Date;
sprmparam6 = sccmd.Parameters.Add("@narration", SqlDbType.VarChar);
sprmparam6.Value = dailyattendancemasterinfo.Narration;
sprmparam6 = sccmd.Parameters.Add("@extra1", SqlDbType.VarChar);
sprmparam6.Value = dailyattendancemasterinfo.Extra1;
sprmparam6 = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam6.Value = dailyattendancemasterinfo.Extra2;
int ineffectedrow = sccmd.ExecuteNonQuery();
if (ineffectedrow > 0)
{
goto end_IL_0001;
}
end_IL_0001 :;
}
catch (Exception ex)
{
Messages.ErrorMessage(ex.ToString());
}
finally
{
base.sqlcon.Close();
}
}
/// <summary>
/// Function to save
/// </summary>
public void SaveFunction()
{
try
{
decimal decResult = HolidaySettings();
if (decResult != 1)
{
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
AttendanceBll BllAttendance = new AttendanceBll();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
AttendanceBll BllAttendanceMaster = new AttendanceBll();
infoDailyAttendanceMaster.Date = Convert.ToDateTime(txtCompanyCurrentdate.Text.ToString());
infoDailyAttendanceMaster.Narration = txtNarrationInMaster.Text.Trim();
infoDailyAttendanceMaster.Extra1 = string.Empty;
infoDailyAttendanceMaster.Extra2 = string.Empty;
int inrowcount = dgvAttendance.RowCount;
decMasterIdForEdit = BllAttendanceMaster.DailyAttendanceAddToMaster(infoDailyAttendanceMaster); // calling @@identity
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
for (int i = 0; i <= inrowcount - 1; i++)
{
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value != null
&& dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Status = dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Narration = dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
BllAttendance.DailyAttendanceDetailsAddUsingMasterId(infoDailyAttendanceDetails);
}
Messages.SavedMessage();
Clear();
}
else
{
Messages.InformationMessage("Selected date is holiday");
}
}
catch (Exception ex)
{
MessageBox.Show("A2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to fill Datagridview
/// </summary>
public void GridFill()
{
try
{
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
AttendanceBll BllAttandance = new AttendanceBll();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
AttendanceBll BllAttandanceMaster = new AttendanceBll();
string strDate = txtCompanyCurrentdate.Text;
if (BllAttandanceMaster.DailyAttendanceMasterMasterIdSearch(strDate))
{
List<DataTable> listObj = new List<DataTable>();
infoDailyAttendanceMaster.Date = Convert.ToDateTime(txtCompanyCurrentdate.Text.ToString());
listObj = BllAttandance.DailyAttendanceDetailsSearchGridFill(txtCompanyCurrentdate.Text.ToString());
dgvAttendance.DataSource = listObj[0];
btnDelete.Enabled = true;
btnSave.Text = "Update";
int inRowCount = dgvAttendance.RowCount;
string strMasterNarration = string.Empty;
for (int i = 0; i < inRowCount; i++)
{
if (dgvAttendance.Rows[i].Cells["MasterNarration"].Value.ToString() != "")
{
strMasterNarration = dgvAttendance.Rows[i].Cells["MasterNarration"].Value.ToString();
}
}
txtNarrationInMaster.Text = strMasterNarration;
}
else
{
List<DataTable> listObj1 = new List<DataTable>();
listObj1 = BllAttandance.DailyAttendanceDetailsSearchGridFill(txtCompanyCurrentdate.Text.ToString());
dgvAttendance.DataSource = listObj1[0];
btnDelete.Enabled = false;
btnSave.Text = "Save";
int inRowCount = dgvAttendance.RowCount;
string strMasterNarration = string.Empty;
for (int i = 0; i < inRowCount; i++)
{
if (dgvAttendance.Rows[i].Cells["MasterNarration"].Value.ToString() != null)
{
strMasterNarration = dgvAttendance.Rows[i].Cells["MasterNarration"].Value.ToString();
}
}
txtNarrationInMaster.Text = strMasterNarration;
}
}
catch (Exception ex)
{
MessageBox.Show("A1" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
//Function to edit
public void EditFunction()
{
try
{
decimal decResult = HolidaySettings();
if (decResult != 1)
{
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
AttendanceBll BllAttendance = new AttendanceBll();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
AttendanceBll BllAttendanceMaster = new AttendanceBll();
infoDailyAttendanceMaster.Date = DateTime.Parse(txtCompanyCurrentdate.Text.ToString());
infoDailyAttendanceMaster.Narration = txtNarrationInMaster.Text.Trim();
infoDailyAttendanceMaster.Extra1 = string.Empty;
infoDailyAttendanceMaster.Extra2 = string.Empty;
int inrowcount = dgvAttendance.RowCount;
for (int i = 0; i <= inrowcount - 1; i++)
{
if (dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value.ToString() != "")
{
decMasterIdForEdit = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value.ToString()); //storing Dailymasterid
}
}
infoDailyAttendanceMaster.DailyAttendanceMasterId = decMasterIdForEdit;
BllAttendanceMaster.DailyAttendanceEditMaster(infoDailyAttendanceMaster);
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
for (int i = 0; i <= inrowcount - 1; i++)
{
if (dgvAttendance.Rows[i].Cells["dgvtxtDailyAttendanceDetailsId"].Value.ToString() != "")
{
// for updation of saved employees
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvtxtDailyAttendanceDetailsId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtDailyAttendanceDetailsId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.DailyAttendanceDetailsId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtDailyAttendanceDetailsId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.DailyAttendanceMasterId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value != null
&& dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Status = dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Narration = dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
BllAttendance.DailyAttendanceDetailsEditUsingMasterId(infoDailyAttendanceDetails);
}
else
{
// for new employees to add
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value != null
&& dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Status = dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Narration = dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
BllAttendance.DailyAttendanceDetailsAddUsingMasterId(infoDailyAttendanceDetails);
}
} // updation of old employees & addition of new employees closes here
Messages.UpdatedMessage();
Clear();
}
else
{
Messages.InformationMessage("Selected date is holiday");
}
}
catch (Exception ex)
{
MessageBox.Show("A3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
//Function to edit
public void EditFunction()
{
try
{
decimal decResult = HolidaySettings();
if (decResult != 1)
{
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
infoDailyAttendanceMaster.Date = DateTime.Parse(txtCompanyCurrentdate.Text.ToString());
infoDailyAttendanceMaster.Narration = txtNarrationInMaster.Text.Trim();
infoDailyAttendanceMaster.Extra1 = string.Empty;
infoDailyAttendanceMaster.Extra2 = string.Empty;
int inrowcount = dgvAttendance.RowCount;
for (int i = 0; i <= inrowcount - 1; i++)
{
if (dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value.ToString() != "")
{
decMasterIdForEdit = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value.ToString()); //storing Dailymasterid
}
}
infoDailyAttendanceMaster.DailyAttendanceMasterId = decMasterIdForEdit;
spDailyAttendanceMaster.DailyAttendanceEditMaster(infoDailyAttendanceMaster);
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
for (int i = 0; i <= inrowcount - 1; i++)
{
if (dgvAttendance.Rows[i].Cells["dgvtxtDailyAttendanceDetailsId"].Value.ToString() != "")
{
// for updation of saved employees
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvtxtDailyAttendanceDetailsId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtDailyAttendanceDetailsId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.DailyAttendanceDetailsId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtDailyAttendanceDetailsId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.DailyAttendanceMasterId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtdailyAttendanceMasterId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Status = dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Narration = dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
spDailyAttendanceDetails.DailyAttendanceDetailsEditUsingMasterId(infoDailyAttendanceDetails);
}
else
{
// for new employees to add
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Status = dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Narration = dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
spDailyAttendanceDetails.DailyAttendanceDetailsAddUsingMasterId(infoDailyAttendanceDetails);
}
} // updation of old employees & addition of new employees closes here
Messages.UpdatedMessage();
Clear();
}
else
{
Messages.InformationMessage("Selected date is holiday");
}
}
catch (Exception ex)
{
MessageBox.Show("A3" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Function to save
/// </summary>
public void SaveFunction()
{
try
{
decimal decResult = HolidaySettings();
if (decResult != 1)
{
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
infoDailyAttendanceMaster.Date = Convert.ToDateTime(txtCompanyCurrentdate.Text.ToString());
infoDailyAttendanceMaster.Narration = txtNarrationInMaster.Text.Trim();
infoDailyAttendanceMaster.Extra1 = string.Empty;
infoDailyAttendanceMaster.Extra2 = string.Empty;
int inrowcount = dgvAttendance.RowCount;
decMasterIdForEdit = spDailyAttendanceMaster.DailyAttendanceAddToMaster(infoDailyAttendanceMaster); // calling @@identity
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
for (int i = 0; i <= inrowcount - 1; i++)
{
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value != null && dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString() != "")
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(dgvAttendance.Rows[i].Cells["dgvtxtColumnEmployeeId"].Value.ToString());
}
if (dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Status = dgvAttendance.Rows[i].Cells["dgvcmbcolumnStatus"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value != null &&
dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString() != "")
{
infoDailyAttendanceDetails.Narration = dgvAttendance.Rows[i].Cells["dgvtxtColumnnarration"].Value.ToString();
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
spDailyAttendanceDetails.DailyAttendanceDetailsAddUsingMasterId(infoDailyAttendanceDetails);
}
Messages.SavedMessage();
Clear();
}
else
{
Messages.InformationMessage("Selected date is holiday");
}
}
catch (Exception ex)
{
MessageBox.Show("A2" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool EditFunction(string date, string tableData)
{
try
{
List <Dictionary <string, object> > items = JsonConvert.DeserializeObject <List <Dictionary <string, object> > >(tableData);
DailyAttendanceDetailsInfo infoDailyAttendanceDetails = new DailyAttendanceDetailsInfo();
DailyAttendanceDetailsSP spDailyAttendanceDetails = new DailyAttendanceDetailsSP();
DailyAttendanceMasterInfo infoDailyAttendanceMaster = new DailyAttendanceMasterInfo();
DailyAttendanceMasterSP spDailyAttendanceMaster = new DailyAttendanceMasterSP();
infoDailyAttendanceMaster.Date = Convert.ToDateTime(date);
infoDailyAttendanceMaster.Narration = string.Empty;
infoDailyAttendanceMaster.Extra1 = string.Empty;
infoDailyAttendanceMaster.Extra2 = string.Empty;
decimal decMasterIdForEdit = 0;
int inrowcount = items.Count;
for (int i = 0; i < inrowcount; i++)
{
string masterId = items[i]["masterId"].ToString() ?? string.Empty;
if (masterId != "")
{
decMasterIdForEdit = Convert.ToDecimal(masterId); //storing Dailymasterid
}
}
infoDailyAttendanceMaster.DailyAttendanceMasterId = decMasterIdForEdit;
spDailyAttendanceMaster.DailyAttendanceEditMaster(infoDailyAttendanceMaster);
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
for (int i = 0; i < inrowcount; i++)
{
string detailsId = items[i]["detailsId"].ToString() ?? string.Empty;
string masterId = items[i]["masterId"].ToString() ?? string.Empty;
string employeeId = items[i]["employeeId"].ToString() ?? string.Empty;
string status = items[i]["status"].ToString() ?? string.Empty;
string narration = items[i]["narration"].ToString() ?? string.Empty;
narration = narration.Replace("\n", "\\n");
if (detailsId != "")
{
// for updation of saved employees
if (employeeId != null && employeeId != "")
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(employeeId);
}
if (detailsId != null && detailsId != "")
{
infoDailyAttendanceDetails.DailyAttendanceDetailsId = Convert.ToDecimal(detailsId);
}
if (masterId != null && masterId != "")
{
infoDailyAttendanceDetails.DailyAttendanceMasterId = Convert.ToDecimal(masterId);
}
if (status != null && status != "")
{
infoDailyAttendanceDetails.Status = status;
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (narration != null && narration != "")
{
infoDailyAttendanceDetails.Narration = narration;
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
spDailyAttendanceDetails.DailyAttendanceDetailsEditUsingMasterId(infoDailyAttendanceDetails);
}
else
{
// for new employees to add
if (employeeId != null && employeeId != "")
{
infoDailyAttendanceDetails.EmployeeId = Convert.ToDecimal(employeeId);
}
if (status != null && status != "")
{
infoDailyAttendanceDetails.Status = status;
}
else
{
infoDailyAttendanceDetails.Status = "Present";
}
if (narration != null && narration != "")
{
infoDailyAttendanceDetails.Narration = narration;
}
else
{
infoDailyAttendanceDetails.Narration = "";
}
infoDailyAttendanceDetails.Extra1 = string.Empty;
infoDailyAttendanceDetails.Extra2 = string.Empty;
infoDailyAttendanceDetails.DailyAttendanceMasterId = decMasterIdForEdit;
spDailyAttendanceDetails.DailyAttendanceDetailsAddUsingMasterId(infoDailyAttendanceDetails);
}
} // updation of old employees & addition of new employees closes here
}
catch (Exception ex)
{
return(false);
}
return(true);
}
