void GetList(int product_Type_ID)
{
ViewData[UIProductType.hidProductTypeID.ToString()] = product_Type_ID.ToString();
BusinessLogic.Product_Type.Product_Type obj = new BusinessLogic.Product_Type.Product_Type();
obj._ID = product_Type_ID;
System.Data.DataSet ds = obj.GetProductTypeAttrubuteList(product_Type_ID);
DataRow[] rows = ds.Tables["List"].Select(""," Attribute_ID Asc");
int previous_attribute_ID = 0;
StringBuilder sb = new StringBuilder();
bool is_From_Detail = false;
foreach (DataRow row in rows)
{
if ( Convert.ToInt32( row["Attribute_ID"] ) != previous_attribute_ID)
{
if (previous_attribute_ID != 0)
sb.Append("</table>");
is_From_Detail = false;
previous_attribute_ID = Convert.ToInt32(row["Attribute_ID"]);
sb.Append("<table width=\"100%\" ").Append("style = 'z-index: 1; top: 0px; left: 0px; display: none;'");
sb.Append(" id='attr").Append(row["Attribute_ID"].ToString()).Append("' class='attributeVariantTable' >");
sb.Append("<tr><td>");
sb.Append("<a href='javascript:NewProductTypeAttributeVariant(").Append(row["Attribute_ID"].ToString()).Append(")' class='abtn ui-state-default ui-corner-all'>").Append(" Add ").Append(row["Attribute"].ToString() ).Append(" variant" ).Append("</a>");
sb.Append("</td></tr>");
if (row["Attribute_Variant"] != null)
{
sb.Append("<tr><td>").Append(row["Attribute_Variant"].ToString()).Append("</td></tr>");
is_From_Detail = true;
}
}
else
{
if (row["Attribute_Variant"] != null)
sb.Append("<tr><td>").Append(row["Attribute_Variant"].ToString()).Append("</td></tr>");
ds.Tables["List"].Rows.Remove( row );
is_From_Detail = true;
}
}
if( is_From_Detail )
sb.Append("</table>");
ViewData[UIProductType.htmlProductTypeAttributeVariant.ToString()] = sb.ToString();
IQueryable<DataRow> dt = ds.Tables["List"].Rows.Cast<DataRow>().AsQueryable();
ViewData[ UIProductType.listProductTypeAttribute.ToString()] = dt.ToList();
}
public ActionResult Save(FormCollection collection)
{
if (!Validation(collection))
{
SetCollectionToView(collection);
return View("NewProductType");
}
DataSet.DSParameter ds = SetViewToDS(collection);
BusinessLogic.Product_Type.Product_Type obj = new BusinessLogic.Product_Type.Product_Type();
obj.New(ds);
return Content(obj._ID.ToString());
}
protected void SetProductType(int product_Type_ID)
{
BusinessLogic.Product_Type.Product_Type obj = new BusinessLogic.Product_Type.Product_Type();
obj._ID = product_Type_ID;
DataSet.DSParameter.Product_TypeRow row = obj.Get().Product_Type.FindByProduct_Type_ID(product_Type_ID);
ViewData[UIProductType.hidProductTypeID.ToString()] = row.Product_Type_ID;
ViewData[UIProductType.txtDescription.ToString()] = "";
ViewData[UIProductType.txtEnterDate.ToString()] = "";
ViewData[UIProductType.txtProductType.ToString()] = row.Product_Type;
ViewData[UIProductType.txtStatus.ToString()] = "";
ViewData["ErrorMessage"] = "";
GetList(product_Type_ID);
}
private void LoadProductTypeList(FormCollection collection, int pageSize, int pageCalled)
{
//int _start;
//int _count;
int _totalCount = 0;
string _product_Type;
_product_Type = collection[UIProductType.txtSerProductType.ToString()];
if (_product_Type != null)
_product_Type = _product_Type.Trim().Length == 0 ? null : _product_Type;
BusinessLogic.Product_Type.Product_Type con = new BusinessLogic.Product_Type.Product_Type();
System.Data.DataSet ds = con.GetPage(((pageCalled - 1) * pageSize + 1), pageSize, ref _totalCount, _product_Type);
try
{
//----------------------------------------------
//Fill Custom Data
//string temp = "";
int totalItems = _totalCount;
Web.Model.Pagination pagination = new Web.Model.Pagination(true);
pagination.BaseUrl = Url.Content("~/ProductType/List/");
pagination.TotalRows = totalItems;
pagination.CurPage = pageCalled;
pagination.PerPage = pageSize;
pagination.PrevLink = "Prev";
pagination.NextLink = "Next";
pagination.UpdateTargetId = "mainSearchPanel";
string pageLinks = pagination.GetPageLinks();
int start = (pageCalled - 1) * pagination.PerPage;
int offset = pagination.PerPage;
ViewData["pageLinks"] = pageLinks;
ViewData["Count"] = totalItems;
IQueryable<DataRow> dt = ds.Tables["List"].Rows.Cast<DataRow>().AsQueryable();
ViewData[UIProductType.listProductType.ToString()] = dt.ToList();
ViewData[UIProductType.hidCurrentPage.ToString()] = pageCalled;
}
catch
{
}
}
public JsonResult Save()
{
CategoryManifest pm = new CategoryManifest();
//
if (!Validate(ref pm))
{
BusinessLogic.Product_Type.Product_Type sp = new BusinessLogic.Product_Type.Product_Type();
DataSet.DSParameter ds = new DataSet.DSParameter();
ds.Product_Type.Product_Type_IDColumn.ReadOnly = false;
ds.Product_Type.AddProduct_TypeRow(pm.category, 1, DateTime.Now, "", pm.is_Active);
ds.EnforceConstraints = false;
ds.Product_Type[0]["Product_Type_ID"] = Convert.ToInt32(pm.category_ID);
if (pm.hidState == 3)
{
sp.New(ds);
}
else
{
sp.Update(ds);
}
UpdateCache();
}
return this.Json(pm, JsonRequestBehavior.AllowGet);
}
