public Sku GetSkuByID(int skuID)
{
skuItem = new Sku();
using (SqlDataReader reader = SKUDAL.GetAllSkus(skuID))
{
while (reader.Read())
{
Sku item = new Sku();
item.SkuId = Convert.ToInt32(reader["SkuId"]);
item.Title = reader["Title"].ToString();
item.SkuCode = reader["SkuCode"].ToString();
item.ShortDescription = reader["ShortDescription"].ToString();
item.LongDescription = reader["LongDescription"].ToString();
item.EmailDescription = reader["EmailDescription"].ToString();
item.CategoryId = Convert.ToInt32(reader["CategoryId"]);
item.FullPrice = Convert.ToDecimal(reader["FullPrice"]);
item.InitialPrice = Convert.ToDecimal(reader["InitialPrice"]);
item.Weight = Convert.ToDecimal(reader["Weight"]);
item.StockQty = (reader["StockQty"] == DBNull.Value) ? 0 : Convert.ToInt32(reader["StockQty"]);
item.OfferCode = reader["OfferCode"].ToString();
item.IsAvailable = Convert.ToBoolean(reader["IsAvailable"]);
item.IsTaxable = Convert.ToBoolean(reader["IsTaxable"]);
item.TaxableFullAmount = Convert.ToDecimal(reader["TaxableFullAmount"]);
item.ImagePath = reader["ImagePath"].ToString();
item.CreateDate = Convert.ToDateTime(reader["CreateDate"]);
item.CreateDate = Convert.ToDateTime(reader["ModifyDate"]);
item.LoadAttributeValues();
skuItem = item;
}
}
return(skuItem);
}
public List <Sku> GetAllSkus(int startRec, int endRec, out int totalCount)
{
List <Sku> SkuList = new List <Sku>();
List <string> assocications = new List <string>();
using (DataTable DtTable = SKUDAL.GetAllSkus(startRec, endRec, out totalCount))
{
foreach (DataRow row in DtTable.Rows)
{
Sku item = new Sku();
item.SkuId = Convert.ToInt32(row["SkuId"]);
item.Title = row["Title"].ToString();
item.SkuCode = row["SkuCode"].ToString();
item.ShortDescription = row["ShortDescription"].ToString();
item.LongDescription = row["LongDescription"].ToString();
item.CategoryId = Convert.ToInt32(row["CategoryId"]);
item.FullPrice = Convert.ToDecimal(row["FullPrice"]);
item.InitialPrice = Convert.ToDecimal(row["InitialPrice"]);
item.Weight = Convert.ToDecimal(row["Weight"]);
item.OfferCode = row["OfferCode"].ToString();
item.IsTaxable = Convert.ToBoolean(row["IsTaxable"]);
item.TaxableFullAmount = Convert.ToDecimal(row["TaxableFullAmount"]);
item.IsAvailable = Convert.ToBoolean(row["IsAvailable"]);
item.CreateDate = Convert.ToDateTime(row["CreateDate"]);
item.ModifyDate = Convert.ToDateTime(row["ModifyDate"]);
SkuList.Add(item);
}
}
return(SkuList);
}
public List <Sku> GetAllSkus()
{
List <Sku> SkuList = new List <Sku>();
using (SqlDataReader reader = SKUDAL.GetAllSkus(0))
{
while (reader.Read())
{
Sku item = new Sku();
item.SkuId = Convert.ToInt32(reader["SkuId"]);
item.Title = reader["Title"].ToString();
item.SkuCode = reader["SkuCode"].ToString();
item.ShortDescription = reader["ShortDescription"].ToString();
item.LongDescription = reader["LongDescription"].ToString();
item.CategoryId = Convert.ToInt32(reader["CategoryId"]);
item.FullPrice = Convert.ToDecimal(reader["FullPrice"]);
item.InitialPrice = Convert.ToDecimal(reader["InitialPrice"]);
item.Weight = Convert.ToDecimal(reader["Weight"]);
item.OfferCode = reader["OfferCode"].ToString();
item.IsTaxable = Convert.ToBoolean(reader["IsTaxable"]);
item.TaxableFullAmount = Convert.ToDecimal(reader["TaxableFullAmount"]);
item.IsAvailable = Convert.ToBoolean(reader["IsAvailable"]);
item.CreateDate = Convert.ToDateTime(reader["CreateDate"]);
item.ModifyDate = Convert.ToDateTime(reader["ModifyDate"]);
item.SkuTitleCode = String.Format("{0} ({1})", CommonHelper.Left(reader["Title"].ToString(), 50), reader["SkuId"].ToString());
item.ImagePath = Convert.IsDBNull(reader["ImagePath"]) ? null : Convert.ToString(reader["ImagePath"]);
SkuList.Add(item);
}
}
return(SkuList);
}
protected void dlSKU_ItemCommand(object sender, DataListCommandEventArgs e)
{
int skuId = (int)dlSkuList.DataKeys[e.Item.ItemIndex];
switch (e.CommandName)
{
case "Delete":
SKUDAL.RemoveSku(Sku.objectName, skuId);
BindSkuList(1, true);
break;
case "Edit":
Response.Redirect("SKUItem.aspx?skuid=" + skuId);
break;
case "Copy":
new SkuManager().CopySku(skuId);
BindSkuList(1, true);
break;
}
}
protected void dlSKU_ItemCommand(object sender, DataListCommandEventArgs e)
{
int skuId = (int)dlSkuList.DataKeys[e.Item.ItemIndex];
int pageNum = 1;
switch (e.CommandName)
{
case "Delete":
SKUDAL.RemoveSku(Sku.objectName, skuId);
if (ViewState["PageNo"] != null)
{
pageNum = (int)ViewState["PageNo"];
}
BindSkuList(pageNum, true);
lblSuccess.Visible = false;
lblCancel.Visible = true;
break;
case "Edit":
Response.Redirect("SKUItem.aspx?skuid=" + skuId);
break;
case "Copy":
new SkuManager().CopySku(skuId);
//int pageNum=1;
if (ViewState["PageNo"] != null)
{
pageNum = (int)ViewState["PageNo"];
}
BindSkuList(pageNum, true);
lblSuccess.Visible = true;
lblCancel.Visible = false;
break;
}
}
public void CopySku(int skuId)
{
SKUDAL.CopySku(skuId, Sku.objectName);
}
public void InsertSku(Sku skuItem)
{
SKUDAL.InsertSku(skuItem.SkuId, Serialize(skuItem));
}
