public int LeaveApplicationAction_BL(EWA_LeaveApplication objEWA) { try { int flag = objDL.LeaveApplicationAction_DL(objEWA); return(flag); } catch (Exception exp) { throw exp; } }
//To Call LeaveBalanceGridBind #region LeaveBalanceGridBind public DataSet LeaveBalanceGridBind_BL(EWA_LeaveApplication objEWA) { try { DataSet ds = objDL.BindLeaveBalanceGrid_DL(objEWA); return(ds); } catch (Exception) { throw; } }
//To Bind LeaveBalanceGrid #region BindLeaveBalanceGrid public DataSet BindLeaveBalanceGrid_DL(EWA_LeaveApplication objEWA) { DataSet ds = new DataSet(); try { prmList = new string[6]; prmList[0] = "@Action"; prmList[1] = objEWA.Action; prmList[2] = "@OrgId"; prmList[3] = objEWA.OrgId.ToString(); prmList[4] = "@UserCode"; prmList[5] = objEWA.UserCode.ToString(); ds = ObjHelper.FillControl(prmList, "SP_LeaveApplication"); } catch (Exception exp) { // GeneralErr(exp.Message.ToString()); throw exp; } return(ds); }
//To Perform Insert,Update,Delete and Search Actions On Device Setting Table #region PerformActionsOnDeviceSetting public int LeaveApplicationAction_DL(EWA_LeaveApplication objEWA) { try { cmd = new SqlCommand("SP_LeaveApplication", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", objEWA.Action); cmd.Parameters.AddWithValue("@UserCode", objEWA.UserCode); cmd.Parameters.AddWithValue("@ApplicationDate", objEWA.ApplicationDate); cmd.Parameters.AddWithValue("@FromDate", objEWA.FromDate); cmd.Parameters.AddWithValue("@ToDate", objEWA.ToDate); cmd.Parameters.AddWithValue("@TotalLeave", objEWA.TotalLeave); cmd.Parameters.AddWithValue("@Reason", objEWA.Reason); cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId); cmd.Parameters.AddWithValue("@LeaveStatus", objEWA.LeaveStatus); SqlParameter tblvaluetype = cmd.Parameters.AddWithValue("@LeaveDetails", objEWA.dtLeaveDetails); //Passing table value parameter tblvaluetype.SqlDbType = SqlDbType.Structured; con.Open(); int flag = cmd.ExecuteNonQuery(); con.Close(); return(flag); } catch (Exception exp) { int err = ((System.Data.SqlClient.SqlException)(exp)).Number; if (err == 547 && objEWA.Action == "Save") { throw new SystemException("Record is in use !!!"); } else { throw exp; } } }