protected void gvCatagoriesYad2_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (!e.CommandName.Equals("AddNew"))
{
return;
}
GridViewRow row = gvCatagoriesYad2.FooterRow;
TextBox tb = (TextBox)row.FindControl("txtNewCategoryName");
//study program name cannot ne empty
if (tb.Text == "")
{
Master.MessageCenter.DisplayErrorMessage(Yad2Strings.GetText(@"CategoryNameRequired"));
return;
}
//study program name must be unique
if (core.DAL.CategoryYad2.FetchByName(tb.Text) != null)
{
Master.MessageCenter.DisplayErrorMessage(Yad2Strings.GetText(@"MessageSaveFailedNameAlreadyExists"));
return;
}
//Insert new User status
CategoryYad2 category = new CategoryYad2();
category.CategoryYad2Name = tb.Text;
category.Save();
// refresh the grid view data
LoadItems();
}
protected void gvCatagoriesYad2_RowUpdate(object sender, GridViewUpdateEventArgs e)
{
int index = e.RowIndex;
GridViewRow row = gvCatagoriesYad2.Rows[index];
Int64 CategoryId = Int64.Parse(gvCatagoriesYad2.DataKeys[index].Value.ToString());
TextBox tb = (TextBox)row.Cells[0].FindControl("txtCategoryName");
//study program name cannot ne empty
if (tb.Text == "")
{
Master.MessageCenter.DisplayErrorMessage(Yad2Strings.GetText(@"CategoryNameRequired"));
return;
}
//category name must be unique
CategoryYad2 category = CategoryYad2.FetchByName(tb.Text);
if (category != null && category.CategoryYad2Id != CategoryId)
{
Master.MessageCenter.DisplayErrorMessage(Yad2Strings.GetText(@"MessageSaveFailedNameAlreadyExists"));
return;
}
category = CategoryYad2.FetchByID(CategoryId);
category.CategoryYad2Name = tb.Text;
category.Save();
gvCatagoriesYad2.EditIndex = -1;
// refresh the grid view data
LoadItems();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//fill status dropDown
string[] names = Enum.GetNames(typeof(StatusType));
Array values = Enum.GetValues(typeof(StatusType));
for (int i = 0; i < names.Length; i++)
{
ddlStatus.Items.Add(new ListItem(Yad2Strings.GetText(names[i]), ((int)values.GetValue(i)).ToString()));
}
}
int CurrentPageIndex = 0;
if (!int.TryParse(hfCurrentPageIndex_dgProductsYad2.Value, out CurrentPageIndex))
{
CurrentPageIndex = 0;
}
if (CurrentPageIndex < 0)
{
CurrentPageIndex = 0;
}
dgProductsYad2.CurrentPageIndex = CurrentPageIndex;
LoadItems();
}
protected void btnExport_Click(object sender, EventArgs e)
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(new System.Data.DataColumn(Yad2Strings.GetText(@"ProductName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(Yad2Strings.GetText(@"LstCategory"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(Yad2Strings.GetText(@"Price"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(Yad2Strings.GetText(@"CityName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(Yad2Strings.GetText(@"ContactName"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(Yad2Strings.GetText(@"Phone"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(Yad2Strings.GetText(@"Details"), typeof(string)));
dt.Columns.Add(new System.Data.DataColumn(Yad2Strings.GetText(@"Status"), typeof(string)));
List <int> StatusIdList = FillStatusList();
List <ProductYad2UI> productsYad2 = ProductYad2Controller.GetAllProductsYad2(StatusIdList);
foreach (ProductYad2UI product in productsYad2)
{
System.Data.DataRow row = dt.NewRow();
row[0] = product.ProductName;
row[1] = (product.LstCategory.Count == 0 || product.LstCategory == null) ? "" : String.Join(", ", product.LstCategory.Select(p => p.CategoryYad2Name));
row[2] = product.Price;
row[3] = product.CityName;
row[4] = product.ContactName;
row[5] = "\"" + product.Phone + "\"";
row[6] = product.Details;
row[7] = Yad2Strings.GetText(Enum.GetName(typeof(StatusType), product.Status));
dt.Rows.Add(row);
}
System.Data.DataRow sumRow = dt.NewRow();
sumRow[0] = Yad2Strings.GetText(@"SumPrice") + " " + productsYad2.Sum(p => p.Price);
dt.Rows.Add(sumRow);
SpreadsheetWriter ex = SpreadsheetWriter.FromDataTable(dt, false, true);
Response.Clear();
Response.AddHeader(@"content-disposition", @"attachment;filename=ProductsYad2Export_" + DateTime.UtcNow.ToString(@"yyyy_MM_dd_HH_mm_ss") + "." + ex.FileExtension);
Response.Charset = @"UTF-8";
Response.ContentEncoding = System.Text.Encoding.UTF8;
Response.Cache.SetCacheability(HttpCacheability.NoCache);
Response.ContentType = ex.FileContentType;
Response.BinaryWrite(System.Text.Encoding.UTF8.GetPreamble());
Response.Write(ex.ToString());
Response.End();
}
protected void gvCatagoriesYad2_RowDelete(object sender, GridViewDeleteEventArgs e)
{
int index = e.RowIndex;
Int64 CategoryId = Int64.Parse(gvCatagoriesYad2.DataKeys[index].Value.ToString());
//check if this service is in use
Query productCategory = new Query(ProductYad2Category.TableSchema)
.Where(ProductYad2Category.Columns.CategoryYad2Id, CategoryId);
if (productCategory.GetCount() > 0)
{
Master.MessageCenter.DisplayErrorMessage(Yad2Strings.GetText(@"MessageDeleteFailedInUse"));
return;
}
CategoryYad2.Delete(CategoryId);
// refresh the grid view data
LoadItems();
}
protected void Page_PreRender(object sender, EventArgs e)
{
Master.PageTitle = Yad2Strings.GetText(@"CategoriesYad2PageTitle");
Master.ActiveMenu = "CategoriesYad2";
}
protected void Page_PreRender(object sender, EventArgs e)
{
Master.PageTitle = Yad2Strings.GetText(@"ProductsYad2PageTitle");
Master.ActiveMenu = "ProductsYad2";
Master.AddClientScriptInclude(@"dgDateManager.js");
}
