public static string GetCompanyNameAndIdForLeft(int C_Id)
{
//string Login = Mydb.ExecuteScalar("select LOGIN from ACCOUNT where LOG_IN_ID=@L", new SqlParameter[] { new SqlParameter("@L", Logid) }, CommandType.Text).ToString();
//if (string.IsNullOrEmpty(Login))
//{
string CompName = Mydb.ExecuteScalar("select COMPANY_NAME from CLIENT where CLIENT_ID=@C", new SqlParameter[] { new SqlParameter("@C", C_Id) }, CommandType.Text).ToString();
JavaScriptSerializer js = new JavaScriptSerializer();
List <ManCompany> mcs = new List <ManCompany>();
ManCompany mc = new ManCompany();
mc.NAME = CompName;
return(js.Serialize(mc));
//return "{\"result\" : \"1\",\"IdComp\" :\"" + C_Id + "\",\"Compname\" :\"" + CompName + "\"}";
//}
//else
//{
// //DataTable dt = Mydb.ExecuteReadertoDataTable("select * from MAN_COMPANY where CLIENT_ID=@C", new SqlParameter[] { new SqlParameter("@C", C_Id) }, CommandType.Text);
// return "{\"result\" : \"2\"}";
//}
}
public static string GetUoById(int id)
{
DataTable dt = Mydb.ExecuteReadertoDataTable("sp_CounstructorAPI_GET_UO_by_ID", new SqlParameter[] { new SqlParameter("@MAN_COMPANY_ID", id) }, CommandType.StoredProcedure);
List <ManCompany> mcs = new List <ManCompany>();
foreach (DataRow dr in dt.Rows)
{
ManCompany row = new ManCompany();
row.MAN_COMPANY_ID = Convert.ToInt32(dr["MAN_COMPANY_ID"]);
row.INN = dr["INN"].ToString();
row.KPP = dr["KPP"].ToString();
row.OKPO = dr["OKPO"].ToString();
row.OGRN = dr["OGRN_OGRNIP"].ToString();
row.NAME = dr["NAME"].ToString();
row.LICENCE = dr["LICENCE"].ToString();
row.ADRESS_ID = dr["ADRESS_ID"].ToString();
row.ADRESS = dr["ADRESS"].ToString();
row.PHONE = dr["PHONE"].ToString();
row.EMAIL = dr["EMAIL"].ToString();
row.VK = dr["VK"].ToString();
row.OK = dr["OK"].ToString();
row.FB = dr["FB"].ToString();
row.TW = dr["TW"].ToString();
row.CLIENT_ID = Convert.ToInt32(dr["CLIENT_ID"]);
row.RS = dr["RS"].ToString();
row.KS = dr["KS"].ToString();
row.BANK_BIK_ID = dr["BANK_BIK_ID"].ToString();
row.BANK_BIK = dr["BANK_BIK"].ToString();
row.BANK_NAME = dr["BANK_NAME"].ToString();
row.BANK_INN = dr["BANK_INN"].ToString();
row.BANK_KRS = dr["BANK_KRS"].ToString();
row.BANK_OGRN = dr["BANK_OGRN"].ToString();
row.SHOP_ID = dr["SHOP_ID"].ToString();
mcs.Add(row);
}
JavaScriptSerializer js = new JavaScriptSerializer();
return(js.Serialize(mcs));
}
