public List <clsJobPersionMasterMember> GetJobPersion() { List <clsJobPersionMasterMember> objList = new List <clsJobPersionMasterMember>(); try { clsSqlHelper objSql = new clsSqlHelper(clsHelper.DBCONNTYPE.GetConnString); SqlParameter[] objParams = new SqlParameter[] { new SqlParameter("@JobPersionID", JobPersionID), new SqlParameter("@UserID", UserID), new SqlParameter("@CompanyID", CompanyID), new SqlParameter("@Action", Mode) }; DataSet ds = objSql.ExecuteDataSet("JobPersionMasterGet", objParams); if (ds != null) { clsJobPersionMasterMember objJobPersion = new clsJobPersionMasterMember(); #region JobPersion if (ds.Tables.Count > 0) { foreach (DataRow r in ds.Tables[1].Rows) { objJobPersion.JobPersionID = Convert.ToInt32(r["JobPersionID"] ?? -1); objJobPersion.JobPersionName = (r["JobPersionName"] ?? "").ToString(); objJobPersion.JobPersionAddress = (r["JobPersionAddress"] ?? "").ToString(); objJobPersion.JobPersionStateFKey = Convert.ToInt32(r["JobPersionStateFKey"] ?? -1); objJobPersion.JobPersionCityFKey = Convert.ToInt32(r["JobPersionCityFKey"] ?? -1); objJobPersion.JobPersionAreaFKey = Convert.ToInt32(r["JobPersionAreaFKey"] ?? -1); objJobPersion.JobPersionContactNo = (r["JobPersionContactNo"] ?? "").ToString(); objJobPersion.JobPersionEmail = (r["JobPersionEmail"] ?? "").ToString(); objJobPersion.JobPersionGSTNo = (r["JobPersionGSTNo"] ?? "").ToString(); objJobPersion.JobPersionCSTNo = (r["JobPersionCSTNo"] ?? "").ToString(); objJobPersion.JobPersionIsActive = Convert.ToInt32(r["JobPersionActive"] ?? 0); objJobPersion.CompanyID = Convert.ToInt32(r["CompanyID"] ?? 0); objJobPersion.JobPersionGSTDate = (r["JobPersionGSTDate"] ?? "").ToString(); objJobPersion.JobPersionCSTDate = (r["JobPersionCSTDate"] ?? "").ToString(); objJobPersion.JobPersionDetai = (r["JobPersionDetai"] ?? "").ToString(); objList.Add(objJobPersion); } } #endregion } return(objList); } catch (Exception ex) { throw ex; } }
public List <clsJobPersionMasterMember> GetJobPersionDetail() { List <clsJobPersionMasterMember> objList = new List <clsJobPersionMasterMember>(); try { clsSqlHelper objSql = new clsSqlHelper(clsHelper.DBCONNTYPE.GetConnString); SqlParameter[] objParams = new SqlParameter[] { new SqlParameter("@JobPersionID", JobPersionID), new SqlParameter("@UserID", UserID), new SqlParameter("@CompanyID", CompanyID), new SqlParameter("@Action", Mode) }; DataSet ds = objSql.ExecuteDataSet("JobPersionMasterGet", objParams); if (ds != null) { clsJobPersionMasterMember objJobPersion = new clsJobPersionMasterMember(); #region JobPersion if (ds.Tables.Count > 0) { foreach (DataRow r in ds.Tables[0].Rows) { objJobPersion.JobPersionDetai = (r["JobPersionDetai"] ?? "").ToString(); objList.Add(objJobPersion); } } #endregion } return(objList); } catch (Exception ex) { throw ex; } }