public string Get_MoreShipping_ForEdit(string id)
{
Company_EntryBL cbl = new Company_EntryBL();
string jsonresult = string.Empty;
if (id != null)
{
DataTable dtinfo = new DataTable();
dtinfo = cbl.Get_MoreShipping_ForEdit(id);
dtinfo.Columns.Add("Total", typeof(System.Int32));
//int count = 0;
if (dtinfo.Rows.Count > 0)
{
foreach (DataRow dr in dtinfo.Rows)
{
dr["Total"] = dtinfo.Rows.Count;
}
//count = dtinfo.Rows.Count;
//ViewBag.Totalcount = count;
jsonresult = JsonConvert.SerializeObject(dtinfo);
return(jsonresult);
}
else
{
jsonresult = JsonConvert.SerializeObject(dtinfo);
return(jsonresult);
}
}
return(null);
}
// GET: Registrations
public ActionResult Company_Entry(string id)
{
MultipleModel model = new MultipleModel();
if (Session["CompanyCD"] != null)
{
if (id != null)
{
ViewBag.Flag = id;
try
{
M_CompanyModel MCmodel = new M_CompanyModel();
M_CompanyTagModel t = new M_CompanyTagModel();
//M_CompanyBrandModel MCBmodel = new M_CompanyBrandModel();
M_BrandModel MBmodel = new M_BrandModel();
//M_CompanyShippingModel ms = new M_CompanyShippingModel();
//List<M_CompanyShippingModel> MSmodel = new List<M_CompanyShippingModel>();
List <M_CompanyTagModel> MTmodel = new List <M_CompanyTagModel>();
Company_EntryBL bl = new Company_EntryBL();
DataSet dsnew = bl.CompanyUpdateView_Edit(id);
if (dsnew.Tables.Count > 0)
{
int count = dsnew.Tables.Count;
for (int i = 0; i < count; i++)
{
DataTable dt = dsnew.Tables[i];
if (dt.Rows.Count > 0)
{
DataColumnCollection columns = dt.Columns;
if (columns.Contains("CompanyName"))
{
MCmodel.CompanyCD = dt.Rows[0]["CompanyCD"].ToString();
MCmodel.CompanyName = dt.Rows[0]["CompanyName"].ToString();
MCmodel.Password = dt.Rows[0]["Password"].ToString();
MCmodel.UserRole = Convert.ToInt32(dt.Rows[0]["UserRole"]);
MCmodel.ShortName = dt.Rows[0]["ShortName"].ToString();
MCmodel.ZipCD1 = dt.Rows[0]["CompanyZipCD"].ToString();
MCmodel.Address1 = dt.Rows[0]["Address1"].ToString();
MCmodel.Address2 = dt.Rows[0]["Address2"].ToString();
MCmodel.TelephoneNo = dt.Rows[0]["TelephoneNo"].ToString();
MCmodel.FaxNo = dt.Rows[0]["FaxNo"].ToString();
MCmodel.PresidentName = dt.Rows[0]["PresidentName"].ToString();
if (String.IsNullOrWhiteSpace(dt.Rows[0]["RankingFlg"].ToString()))
{
MCmodel.RankingFlg = 2;
}
else
{
MCmodel.RankingFlg = Convert.ToInt32(dt.Rows[0]["RankingFlg"]);
}
}
//if (columns.Contains("ShippingID"))
//{
// //DataView view1 = new DataView(dt);
// //DataTable distinctValues1 = view1.ToTable(true, "ShippingID", "ShippingName", "ShippingZipCD", "ShippingAddress1", "ShippingAddress2", "ShippingTelephoneNo","ShippingFaxNo");
// MSmodel = dt.AsEnumerable().Select(r =>
// new M_CompanyShippingModel
// {
// ShippingID = Convert.ToInt32(r["ShippingID"]),
// ShippingName = r["ShippingName"].ToString(),
// ZipCD1 = r["ShippingZipCD"].ToString(),
// Address1 = r["ShippingAddress1"].ToString(),
// Address2 = r["ShippingAddress2"].ToString(),
// TelephoneNO = r["ShippingTelephoneNo"].ToString(),
// FaxNO = r["ShippingFaxNo"].ToString()
// }).Distinct().ToList();
//}
if (columns.Contains("Tag"))
{
DataView view = new DataView(dt);
DataTable distinctValues = view.ToTable(true, "CompanyCD", "Tag");
MTmodel = distinctValues.AsEnumerable().Select(r =>
new M_CompanyTagModel
{
CompanyCD = r["CompanyCD"].ToString(),
Tag = r["Tag"].ToString()
}
).Distinct().ToList();
}
if (columns.Contains("BrandName"))
{
MBmodel.BrandName = dt.Rows[0]["BrandName"].ToString();
}
}
}
}
//if (MSmodel.Count < 5)
//{
// int sc = MSmodel.Count;
// int tc = 4;
// int nq = tc - sc;
// int O = nq + sc;
// for (int P = sc; P < O; P++)
// {
// ms.CompanyCD = "";
// ms.ShippingID = null;
// ms.ShippingName = "";
// ms.ZipCD1 = "";
// ms.ZipCD2 = "";
// ms.Address1 = "";
// ms.Address2 = "";
// ms.TelephoneNO = "";
// ms.FaxNO = "";
// MSmodel.Add(ms);
// }
//}
int N = MTmodel.Count;
int M = 20;
int NK = M - N;
int n = N + NK;
for (int j = N; j < n; j++)
{
t.CompanyCD = "";
t.Tag = "";
MTmodel.Add(t);
}
model.TagModel = MTmodel;
//model.ShippingModel = MSmodel;
model.ComModel = MCmodel;
model.MBrandModel = MBmodel;
DataTable dtinfo1 = new DataTable();
Company_EntryBL cbl = new Company_EntryBL();
dtinfo1 = cbl.Get_MoreShipping_ForEdit(id);
int totalcount = 0;
if (dtinfo1.Rows.Count > 0)
{
totalcount = dtinfo1.Rows.Count + 1;
ViewBag.Totalcount = totalcount;
}
}
catch (Exception ex)
{
}
}
else
{
ViewBag.Flag = "";
}
return(View(model));
}
else
{
return(RedirectToAction("Login", "User"));
}
}