public void Save_Report(ArrayList arrlist)
{
DataTable dt = new DataTable();
dt = new DataTable("Report");
dt.Columns.Add("CONTROL_KEY", typeof(string));
dt.Columns.Add("CONTROL_VALUE", typeof(string));
for (int i = 0; i < arrlist.Count; i++)
{
PReportDAO obj = new PReportDAO();
obj = (PReportDAO)arrlist[i];
DataRow row = dt.NewRow();
row["CONTROL_KEY"] = obj.SZCONTROLKEY;
row["CONTROL_VALUE"] = obj.SZCONTROLVALUE;
dt.Rows.Add(row);
}
conn = new SqlConnection(strsqlcon);
try
{
{
conn.Open();
comm = new SqlCommand("SP_PREPORT", conn);
comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
comm.CommandType = CommandType.StoredProcedure;
SqlParameter tblvaluetype = comm.Parameters.AddWithValue("@preport", dt); //Passing table value parameter
tblvaluetype.SqlDbType = SqlDbType.Structured; // This one is used to tell ADO.NET we are passing Table value Parameter
int result = comm.ExecuteNonQuery();
}
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
conn.Close();
}
}
public DataSet loadsearch(ArrayList arr)
{
SqlDataAdapter da;
SqlConnection conn;
SqlCommand comm;
DataSet ds = new DataSet();
conn = new SqlConnection();
try
{
conn.Open();
comm = new SqlCommand("SP_GET_VISIT_OF_REF_OFF_LIST", conn);
comm.CommandTimeout = Convert.ToInt32(ConfigurationManager.AppSettings["CommandTimeOut"].ToString());
comm.CommandType = CommandType.StoredProcedure;
comm.Connection = conn;
for (int i = 0; i < arr.Count; i++)
{
PReportDAO obj = new PReportDAO();
obj = (PReportDAO)arr[i];
comm.Parameters.AddWithValue("@SZ_COMPANY_ID", obj.SCOMPANY);
comm.Parameters.AddWithValue("@SZ_OFFICE_ID", obj.SOFFICE);
comm.Parameters.AddWithValue("@SZ_PROCEDURE_GROUP_ID", obj.SSPECIALITY);
//comm.Parameters.AddWithValue("", obj.DTTYPE);
comm.Parameters.AddWithValue("@DT_FROM_VISIT_DATE", obj.DTFROM);
comm.Parameters.AddWithValue("@DT_TO_VISIT_DATE", obj.DTTO);
}
da = new SqlDataAdapter(comm);
da.Fill(ds);
}
catch (Exception ex)
{
Elmah.ErrorSignal.FromCurrentContext().Raise(ex);
}
finally
{
conn.Close();
}
return(ds);
}
