public int UpdateNewMonthlyLeaveDetails(MonthlyLeaveUploadModel objMonthlyLeaveUploadModel)
{
SqlParameter[] paramAdd = new SqlParameter[4];
paramAdd[0] = new SqlParameter("@UploadYearID", SqlDbType.Int);
paramAdd[0].Value = objMonthlyLeaveUploadModel.MonthlyLeaveUploadId;
paramAdd[1] = new SqlParameter("@Year", SqlDbType.Int);
paramAdd[1].Value = objMonthlyLeaveUploadModel.LeaveYear;
paramAdd[2] = new SqlParameter("@Month", SqlDbType.VarChar, 15);
paramAdd[2].Value = objMonthlyLeaveUploadModel.LeaveMonth;
paramAdd[3] = new SqlParameter("@Days", SqlDbType.Float);
paramAdd[3].Value = objMonthlyLeaveUploadModel.LeaveDays;
try
{
return(SqlHelper.ExecuteNonQuery(ConnectionString, CommandType.StoredProcedure, "UpdateMonthlyLeaveUpload", paramAdd));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "MonthlyLeaveUploadDAL.cs", "UpdateNewMonthlyLeaveDetails", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public int UpdateNewMonthlyLeaveDetails(MonthlyLeaveUploadModel objMonthlyLeaveUploadModel)
{
try
{
return(objMonthlyLeaveUploadDAL.UpdateNewMonthlyLeaveDetails(objMonthlyLeaveUploadModel));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "MonthlyLeaveUploadBOL.cs", "UpdateDepartmentDetails", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
public DataSet BindData(MonthlyLeaveUploadModel objMonthlyLeaveUploadModel)
{
{
try
{
SqlParameter[] paramAdd = new SqlParameter[1];
paramAdd[0] = new SqlParameter("@Year", SqlDbType.Int);
paramAdd[0].Value = objMonthlyLeaveUploadModel.LeaveYear;
return(SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "GetMonthlyLeaveUpload", paramAdd));
}
catch (V2Exceptions ex)
{
throw;
}
catch (System.Exception ex)
{
FileLog objFileLog = FileLog.GetLogger();
objFileLog.WriteLine(LogType.Error, ex.Message, "MonthlyLeaveUploadDAL.cs", "BindData", ex.StackTrace);
throw new V2Exceptions(ex.ToString(), ex);
}
}
}
public DataSet BindData(MonthlyLeaveUploadModel objMonthlyLeaveUploadModel)
{
return(objMonthlyLeaveUploadDAL.BindData(objMonthlyLeaveUploadModel));
}
