/// <summary>
/// Function to update Daily Attendance Master
/// </summary>
/// <param name="dailyattendancemasterinfo"></param>
public void DailyAttendanceEditMaster(DailyAttendanceMasterInfo dailyattendancemasterinfo)
{
try
{
if (sqlcon.State == ConnectionState.Closed)
{
sqlcon.Open();
}
SqlCommand sccmd = new SqlCommand("DailyAttendanceEditMaster", 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("@extra1", SqlDbType.VarChar);
sprmparam.Value = dailyattendancemasterinfo.Extra1;
sprmparam = sccmd.Parameters.Add("@extra2", SqlDbType.VarChar);
sprmparam.Value = dailyattendancemasterinfo.Extra2;
int ineffectedrow = sccmd.ExecuteNonQuery();
if (ineffectedrow > 0)
{
}
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
finally
{
sqlcon.Close();
}
}
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
{
SpDailyAttendanceMaster.DailyAttendanceEditMaster(dailyattendancemasterinfo);
}
catch(Exception ex)
{
MessageBox.Show("A9" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
