public DataSet GetDPODetails(ContactUsSchema objContactUs)
{
try
{
ds = objContactDAL.GetDPODetails(objContactUs);
return(ds);
}
catch (Exception e)
{
return(null);
}
finally
{
ds = null;
}
}
public static List <ContactUsSchema> BindDpoDetails()
{
List <ContactUsSchema> DPOData = new List <ContactUsSchema>();
try
{
ContactUsSchema objcontact = new ContactUsSchema();
ContactUsBL objContactUsBL = new ContactUsBL();
DataSet ds = new DataSet();
objcontact.Langid = LangID;
ds = objContactUsBL.GetDPODetails(objcontact);
string str = Newtonsoft.Json.JsonConvert.SerializeObject(ds.Tables[0]);
JavaScriptSerializer json_serializer = new JavaScriptSerializer();
DPOData = JsonConvert.DeserializeObject <List <ContactUsSchema> >(str.ToString());
}
catch (Exception EX)
{
}
return(DPOData);
}
public DataSet GetDPODetails(ContactUsSchema ObjContactUsSchema)
{
SqlConnection objConn = SQLHelper.OpenConnection();
try
{
SqlParameter[] param = new SqlParameter[1];
param[0] = new SqlParameter("@LangID", SqlDbType.Int);
param[0].Value = ObjContactUsSchema.Langid;
using (DataSet ds = SQLHelper.ExecuteDataset(objConn, null, CommandType.StoredProcedure, "Usp_GetDPODetails", param))
{
return(ds);
}
}
catch (Exception ex)
{
return(null);
}
finally
{
SQLHelper.CloseConnection(objConn);
}
}