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