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)); }