public string Get_Detail_Information()
{
M_CompanyModel mc = new M_CompanyModel();
mc.CompanyCD = Session["CompanyCD"].ToString();
InformationBL ibl = new InformationBL();
return(DataTableToJSONWithJSONNet(ibl.GetInformation(mc)));
}
public DataTable GetInformation(M_CompanyModel mc)
{
BaseDL bdl = new BaseDL();
M_CompanyModel mdl = new M_CompanyModel();
T_InformationModel tmodel = new T_InformationModel();
DataTable dtinfo = new DataTable();
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@companyCD", SqlDbType.VarChar)
{
Value = mc.CompanyCD
};
dtinfo = bdl.SelectData("T_Information_Select_ForHomePage", prms);
return(dtinfo);
}
public M_CompanyModel CheckLogin(M_CompanyModel mcmodel)
{
TOSEntities ent = new TOSEntities();
M_Company mc = ent.M_Company.Where(m => m.CompanyCD == mcmodel.CompanyCD && m.Password == mcmodel.Password).SingleOrDefault();
if (mc == null)
{
return(null);
}
else
{
mcmodel.CompanyName = mc.CompanyName;
mcmodel.UserRole = mc.UserRole;
return(mcmodel);
}
}
public ActionResult CheckLogin(M_CompanyModel cm)
{
M_CompanyModel mc = cbl.CheckLogin(cm);
if (mc == null)
{
return(RedirectToAction("Login", "User", new { @errorId = 1 }));
}
else
{
Session["CompanyName"] = mc.CompanyName.ToString();
Session["CompanyCD"] = mc.CompanyCD.ToString();
if (mc.UserRole == 2)
{
Session["UserRole"] = null;
}
else
{
Session["UserRole"] = mc.UserRole.ToString();
}
return(RedirectToAction("Index", "Home"));
}
}
public ActionResult CompanyUpdate_View(M_CompanyModel mModel)
{
return(View());
}
// 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"));
}
}
