public IHttpActionResult List(Dictionary <string, object> SearchData)
{
try
{
using (LovService obj = new LovService())
return(Ok(obj.List(SearchData)));
}
catch (Exception Ex)
{
return(ResponseMessage(Request.CreateErrorResponse(HttpStatusCode.BadRequest, Ex.Message.ToString())));
}
}
public Dictionary <string, object> GetRecord(Dictionary <string, object> SearchData, string ServerImageUrl)
{
Dictionary <string, object> RetData = new Dictionary <string, object>();
DataRow DROW = null;
pim_docm mRow = new pim_docm();
List <tablesd> mList = new List <tablesd>();
tablesd mRec = new tablesd();
LovService Lov = new LovService();
string pkid = SearchData["pkid"].ToString();
string comp_code = SearchData["comp_code"].ToString();
string table_name = SearchData["table_name"].ToString();
try
{
DataTable Dt_Rec = new DataTable();
string str = ReadColumns(table_name, comp_code);
sql = " select grp_name, doc_table_name,doc_pkid,doc_grp_id,grp_level_name, doc_store_id, d.comp_name as store_name, ";
sql += " doc_slno, doc_name, doc_file_name, doc_thumbnail ";
if (str.Length > 0)
{
sql += "," + str;
}
sql += " from pim_docm a ";
sql += " left join " + table_name + " b on a.doc_pkid = b.doc_parent_id ";
sql += " left join pim_groupm c on a.doc_grp_id = c.grp_pkid ";
sql += " left join companym d on a.doc_store_id = d.comp_pkid ";
sql += " where doc_pkid = '" + pkid + "'";
Con_Oracle = new DBConnection();
Dt_Rec = Con_Oracle.ExecuteQuery(sql);
Con_Oracle.CloseConnection();
if (Dt_Rec.Rows.Count > 0)
{
DROW = Dt_Rec.Rows[0];
}
foreach (DataRow Dr in Dt_Rec.Rows)
{
mRow = new pim_docm();
mRow.doc_pkid = Dr["doc_pkid"].ToString();
mRow.doc_slno = Lib.Conv2Integer(Dr["doc_slno"].ToString());
mRow.doc_store_id = Dr["doc_store_id"].ToString();
mRow.doc_store_name = Dr["store_name"].ToString();
mRow.doc_grp_id = Dr["doc_grp_id"].ToString();
mRow.doc_grp_level_name = Dr["grp_level_name"].ToString();
mRow.doc_name = Dr["doc_name"].ToString();
mRow.doc_file_name = Dr["doc_file_name"].ToString();
mRow.doc_table_name = Dr["doc_table_name"].ToString();
mRow.doc_thumbnail = Dr["doc_thumbnail"].ToString();
mRow.doc_server_folder = Lib.getPath(ServerImageUrl, comp_code, table_name, mRow.doc_slno.ToString(), false);
mRow.doc_file_uploaded = false;
break;
}
Dt_Rec = new DataTable();
sql = " select tab_name, tab_table_name, b.* from ";
sql += " tablesm a inner join tablesd b on a.tab_pkid = tabd_parent_id ";
sql += " where a.rec_company_code = '" + comp_code + "' and tab_table_name = '" + table_name + "' and b.rec_deleted ='N'";
sql += " order by tabd_col_order ";
Con_Oracle = new DBConnection();
Dt_Rec = Con_Oracle.ExecuteQuery(sql);
Con_Oracle.CloseConnection();
foreach (DataRow Dr in Dt_Rec.Rows)
{
mRec = new tablesd();
mRec.tabd_table_name = Dr["tab_table_name"].ToString();
mRec.tabd_col_name = Dr["tabd_col_name"].ToString();
mRec.tabd_col_caption = Dr["tabd_col_caption"].ToString();
mRec.tabd_col_type = Dr["tabd_col_type"].ToString();
mRec.tabd_col_case = Dr["tabd_col_case"].ToString();
mRec.tabd_col_mandatory = Dr["tabd_col_mandatory"].ToString();
mRec.tabd_col_rows = Lib.Conv2Integer(Dr["tabd_col_rows"].ToString());
if (Dr["tabd_col_type"].ToString() == "DATE")
{
mRec.tabd_col_value = Lib.DatetoString(DROW["COL_" + Dr["tabd_col_name"].ToString()]);
}
else if (Dr["tabd_col_type"].ToString() == "LIST")
{
mRec.tabd_col_list = Dr["tabd_col_list"].ToString();
mRec.tabd_col_id = DROW["COL_" + Dr["tabd_col_name"].ToString()].ToString();
mRec.tabd_col_value = "";
if (Dr["tabd_col_id"].ToString().Length > 0)
{
mRec.tabd_col_value = Lov.getParamValue(comp_code, DROW["COL_" + Dr["tabd_col_name"].ToString()].ToString(), "PARAM_NAME");
}
}
else
{
mRec.tabd_col_value = DROW["COL_" + Dr["tabd_col_name"].ToString()].ToString();
}
mRec.tabd_col_len = Lib.Conv2Integer(Dr["tabd_col_len"].ToString());
mRec.tabd_col_dec = Lib.Conv2Integer(Dr["tabd_col_dec"].ToString());
mRec.tabd_col_order = Lib.Conv2Integer(Dr["tabd_col_order"].ToString());
mRec.tabd_col_file_uploaded = false;
mList.Add(mRec);
}
}
catch (Exception Ex)
{
if (Con_Oracle != null)
{
Con_Oracle.CloseConnection();
}
throw Ex;
}
RetData.Add("record", mRow);
RetData.Add("list", mList);
return(RetData);
}
