protected void btnnext_Click(object sender, EventArgs e)
{
iProductMasterClient productClient = new iProductMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
try
{
ds = productClient.GetPriceImportData(DeptID, profile.DBConnection._constr);
dt = ds.Tables[0];
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
string SkuCode = ds.Tables[0].Rows[i]["SKUCode"].ToString();
decimal Price = decimal.Parse(ds.Tables[0].Rows[i]["Price"].ToString());
productClient.UpdateImportSkuPrice(SkuCode, Price, DeptID, profile.DBConnection._constr);
}
productClient.DeleteSKUPricetemp(profile.DBConnection._constr);
Response.Redirect("ImportPriceF.aspx");
}
catch
{
productClient.DeleteSKUPricetemp(profile.DBConnection._constr);
}
finally
{
productClient.Close();
}
}
public void DisplayGrid()
{
iProductMasterClient productClient = new iProductMasterClient();
CustomProfile profile = CustomProfile.GetProfile();
ds = productClient.GetPriceImportData(DeptID, profile.DBConnection._constr);
dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
GVImportView.DataSource = ds.Tables[0];
GVImportView.DataBind();
}
else
{
value = 3;
}
if (value == 0)
{
btnnext.Enabled = false;
btnnext.CssClass = "class1";
lblbackMessage.Text = "Colored Row SKU not Available in OMS.Please click on Back Button";
}
else if (value == 2)
{
btnnext.Enabled = false;
btnnext.CssClass = "class1";
lblbackMessage.Text = "Characters and blank values not asccepted in Price columns";
}
else if (value == 3)
{
btnnext.Enabled = false;
btnnext.CssClass = "class1";
lblbackMessage.Text = "Please Select Correct Company and department for Uploading SKU price";
}
else
{
lblOkMessage.Text = "All data are verified.Please click on Next Button ";
btnnext.Enabled = true;
btnnext.CssClass = "class2";
}
}
