private void BindClaimSkuDetail(int claimSkuDetailId)
{
try
{
ClaimSku claimSkuDetail = ClaimSku.GetClaimSkuDetailByClaimSkuDetailId(claimSkuDetailId);
HiddenFieldClaimSkuDetailId.Value = claimSkuDetailId.ToString();
DropDownListCategory.Items.Clear();
DropDownListSubCategory.Items.Clear();
BindClaimSkuCategory();
DropDownListCategory.Items.FindByValue(claimSkuDetail.ClaimSkuCategoryId.ToString()).Selected = true;
BindClaimSkuSubCategory();
DropDownListSubCategory.Items.FindByValue(claimSkuDetail.ClaimSkuSubCategoryId.ToString()).Selected = true;
TextBoxQuantity.Text = claimSkuDetail.Quantity.ToString();
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
for (int i = 0; i < sqlEx.Errors.Count; i++)
{
LabelError.Text += (sqlEx.Errors[i].Message + "<br />");
}
PanelError.Visible = true;
}
catch (Exception exception)
{
LabelError.Text += (exception.Message + "<br />");
PanelError.Visible = true;
}
}
protected void DropDownListStore_SelectedIndexChanged(object sender, EventArgs e)
{
if (Roles.IsUserInRole("RepClaim"))
{
BindRepStoreClaimMonth();
return;
}
ListBoxClaimMonth.DataSource = ClaimSku.GetClaimSkuMonthByStore(Convert.ToInt32(DropDownListStore.SelectedValue), Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId);
ListBoxClaimMonth.DataTextField = "FormattedClaimDate";
//ListBoxClaimMonth.DataValueField = "ClaimSkuId";
ListBoxClaimMonth.DataBind();
ListBoxClaimMonth.Enabled = ListBoxClaimMonth.Items.Count > 0;
GridViewResult.DataBind();
TextBoxClaimNumber.Text = "";
if (ListBoxClaimMonth.Items.Count == 0)
{
ListBoxClaimMonth.Items.Clear();
}
else
{
ListBoxClaimMonth.Items.Insert(0, new ListItem("ALL", "0"));
}
}
private void BindClaimSku()
{
try
{
ClaimSku claimSku = ClaimSku.GetClaimSkuByClaimSkuId(this.claimSkuId);
TextBoxCaptureDate.Text = String.Format("{0:d/M/yyyy HH:mm:ss}", claimSku.CreatedDate);
//BindLocationList();
//DropDownListLocation.Items.FindByValue(Location.GetLocationByStoreId(claimSku.StoreId).LocationId.ToString()).Selected = true;
BindStore();
//Supplier Name Change
string supplierNameChange = (claimSku.Supplier == "Honeydew") ? "Monteagle Dairies(Honeydew)" : claimSku.Supplier;
DropDownListSupplier.Items.FindByText(supplierNameChange).Selected = true;
//DropDownListSupplier.Items.FindByText(claimSku.Supplier).Selected = true;
DropDownListStore.Items.FindByValue(claimSku.StoreId.ToString()).Selected = true;
//DropDownListLocation.Items.FindByValue(Location.GetLocationByStoreId(claimSku.StoreId).LocationId.ToString()).Selected = true;
TextBoxClaimDate.Text = claimSku.FormattedClaimDateEdit.ToString();
TextBoxClaimNumber.Text = claimSku.ClaimNumber;
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
for (int i = 0; i < sqlEx.Errors.Count; i++)
{
LabelError.Text += (sqlEx.Errors[i].Message + "<br />");
}
PanelError.Visible = true;
}
catch (Exception exception)
{
LabelError.Text += (exception.Message + "<br />");
PanelError.Visible = true;
}
}
protected void ListBoxClaimMonth_SelectedIndexChanged(object sender, EventArgs e)
{
string claimMonth = "";
for (int i = 0; i < ListBoxClaimMonth.Items.Count; i++)
{
if (ListBoxClaimMonth.Items[i].Selected == true)
{
if (ListBoxClaimMonth.Items[i].Text == "ALL")
{
for (int j = 0; j < ListBoxClaimMonth.Items.Count; j++)
{
claimMonth += ListBoxClaimMonth.Items[j].Text + ",";
}
}
else
{
claimMonth += ListBoxClaimMonth.Items[i].Text + ",";
}
}
}
GridViewResult.DataSource = ClaimSku.GetClaimSkuListByClaimMonthAndStoreId(claimMonth, Convert.ToInt32(DropDownListStore.SelectedValue), Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId);
GridViewResult.DataBind();
}
private void BindClaimSkuSubCategory()
{
DropDownListSubCategory.ClearSelection();
DropDownListSubCategory.DataSource = ClaimSku.GetClaimSkuSubCategoryListByClaimSkuCategory(Convert.ToInt32(DropDownListCategory.SelectedValue));
DropDownListSubCategory.DataTextField = "Description";
DropDownListSubCategory.DataValueField = "ClaimSkuSubCategoryId";
DropDownListSubCategory.DataBind();
}
private void BindClaimSkuSubCategory()
{
DropDownListSubCategory.DataSource = ClaimSku.GetClaimSkuSubCategoryListByClaimSkuCategory(Convert.ToInt32(DropDownListCategory.SelectedValue));
DropDownListSubCategory.DataTextField = "Description";
DropDownListSubCategory.DataValueField = "ClaimSkuSubCategoryId";
DropDownListSubCategory.DataBind();
//DropDownListSubCategory.Items.Insert(0, new ListItem("Please select", "0"));
}
private void BindClaimSkuCategory()
{
DropDownListCategory.DataSource = ClaimSku.GetClaimSkuCategoryList();
DropDownListCategory.DataTextField = "Description";
DropDownListCategory.DataValueField = "ClaimSkuCategoryId";
DropDownListCategory.DataBind();
DropDownListCategory.Items.Insert(0, new ListItem("Please select", "0"));
}
protected void GridViewResult_DataBinding(object sender, EventArgs e)
{
List <ClaimSku> claimSkuList = ClaimSku.GetClaimSkuDetailListByClaimSkuId(this.claimSkuId);
if (claimSkuList.Count > 0)
{
GridViewResult.Columns[2].HeaderText = claimSkuList[0].FormattedQuantity;
}
}
private void BindRepGridViewResult()
{
BindStore();
ListBoxClaimMonth.Items.Clear();
GridViewResult.DataSource = ClaimSku.GetClaimSkuListByClaimNumberAndUserName(((TextBoxClaimNumber.Text.Length == 0) ? "" : TextBoxClaimNumber.Text), Page.User.Identity.Name.ToString());
GridViewResult.DataBind();
if (GridViewResult.Rows.Count == 0)
{
GridViewResult.DataBind();
}
}
private void GenerateReportClaimSku()
{
int index = 1;
string sFileName = System.IO.Path.GetRandomFileName().Substring(0, 8);
string sGenName = "ReportClaimSkuNational.csv";
using (System.IO.StreamWriter SW = new System.IO.StreamWriter(Server.MapPath("Upload/" + sFileName + ".csv")))
{
SW.WriteLine(String.Format("STORE CLAIMS BY SKU NATIONAL - {0}", DropDownListMonth.SelectedItem.Text));
SW.WriteLine(String.Format("{0}", DropDownListSupplier.SelectedItem.Text));
SW.WriteLine("");
string row = "";
//Supplier Name Change
string supplierNameChange = (DropDownListSupplier.SelectedItem.Text == "Monteagle Dairies(Honeydew)") ? "Honeydew" : DropDownListSupplier.SelectedItem.Text;
List <ClaimSku> claimSkuSubCategoryList = ClaimSku.GetReportClaimSkuSubCategoryNational(Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId, DropDownListMonth.SelectedItem.Text, supplierNameChange);
if (claimSkuSubCategoryList.Count > 0)
{
SW.WriteLine("TOTALS BY LINE ITEMS");
SW.WriteLine("");
SW.WriteLine("LINE ITEM, QUANTITY");
SW.WriteLine("");
foreach (ClaimSku claimSkuSubCategory in claimSkuSubCategoryList)
{
row = String.Format("{0}, {1}", claimSkuSubCategory.ClaimSkuSubCategory, claimSkuSubCategory.Quantity);
SW.WriteLine(row);
index++;
}
SW.Close();
}
else
{
LabelError.Text = "No rows returned.";
PanelError.Visible = true;
}
}
System.IO.FileStream fs = null;
fs = System.IO.File.Open(Server.MapPath("Upload/" + sFileName + ".csv"), System.IO.FileMode.Open);
byte[] btFile = new byte[fs.Length];
fs.Read(btFile, 0, Convert.ToInt32(fs.Length));
fs.Close();
Response.AddHeader("Content-disposition", "attachment; filename=" + sGenName);
Response.ContentType = "application/octet-stream";
Response.BinaryWrite(btFile);
Response.End();
}
private void DeleteClaimSkuDetail(int claimSkuDetailId)
{
try
{
ClaimSku.DeleteClaimSkuDetailByClaimSkuDetailId(claimSkuDetailId);
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
LabelError.Text = "";
for (int i = 0; i < sqlEx.Errors.Count; i++)
{
LabelError.Text += (sqlEx.Errors[i].Message + "<br />");
}
PanelError.Visible = true;
PanelErrorSpace.Visible = true;
}
}
protected void ButtonSearch_Click(object sender, EventArgs e)
{
if (Roles.IsUserInRole("RepClaim"))
{
BindRepGridViewResult();
return;
}
BindStore();
ListBoxClaimMonth.Items.Clear();
GridViewResult.DataSource = ClaimSku.GetClaimSkuListByClaimNumber(((TextBoxClaimNumber.Text.Length == 0) ? "" : TextBoxClaimNumber.Text), Account.GetAccountByUserName(Page.User.Identity.Name.ToString()).AccountId);
GridViewResult.DataBind();
if (GridViewResult.Rows.Count == 0)
{
GridViewResult.DataBind();
}
}
private void BindRepStoreClaimMonth()
{
ListBoxClaimMonth.DataSource = ClaimSku.GetClaimSkuMonthByStoreAndUserName(Convert.ToInt32(DropDownListStore.SelectedValue), Page.User.Identity.Name.ToString());
ListBoxClaimMonth.DataTextField = "FormattedClaimDate";
//ListBoxClaimMonth.DataValueField = "ClaimSkuId";
ListBoxClaimMonth.DataBind();
ListBoxClaimMonth.Enabled = ListBoxClaimMonth.Items.Count > 0;
GridViewResult.DataBind();
TextBoxClaimNumber.Text = "";
if (ListBoxClaimMonth.Items.Count == 0)
{
ListBoxClaimMonth.Items.Clear();
}
else
{
ListBoxClaimMonth.Items.Insert(0, new ListItem("ALL", "0"));
}
}
protected void ButtonDelete_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
try
{
ClaimSku.DeleteClaimSkuByClaimSkuId(this.claimSkuId);
//string message = String.Format("ClaimSku deleted - ClaimSkuId:{0}, ClaimSkuNumber:{1}, , FirstName:{2},, LastName:{3},StatusId:{4}, User:{5}", this.claimSkuId, TextBoxClaimSkuNumber.Text, TextBoxFirstName.Text, TextBoxLastName.Text, 1 /*DropDownListStatusId.SelectedValue*/, this.Master.LoggedOnAccount);
//Utility.WriteLog(1000, 5, message, "Activity", TraceEventType.Information, "ClaimSku");
Response.Redirect("ClaimSkuList.aspx");
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
LabelError.Text = "";
for (int i = 0; i < sqlEx.Errors.Count; i++)
{
LabelError.Text += (sqlEx.Errors[i].Message + "<br />");
}
PanelError.Visible = true;
PanelErrorSpace.Visible = true;
}
}
}
protected void ButtonSaveCategory_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
bool hasError = false;
LabelError.Text = "";
PanelError.Visible = false;
PanelErrorSpace.Visible = false;
if (DropDownListCategory.SelectedValue == "0")
{
LabelError.Text = "<br /> Category is required.<br />";
hasError = true;
}
//if (TextBoxQuantity.Text.Length == 0)
//{
// LabelError.Text += "Quantity is required.";
// hasError = true;
//}
int quantity;
bool isNumeric = int.TryParse(TextBoxQuantity.Text, out quantity);
if (!isNumeric)
{
LabelError.Text += "Valid Quantity is required.";
hasError = true;
}
if (hasError == true)
{
PanelError.Visible = true;
PanelErrorSpace.Visible = true;
return;
}
ClaimSku claimSkuDetail = new ClaimSku();
claimSkuDetail.ClaimSkuDetailId = (HiddenFieldClaimSkuDetailId.Value.Length > 0) ? Convert.ToInt32(HiddenFieldClaimSkuDetailId.Value) : 0;
claimSkuDetail.ClaimSkuId = this.claimSkuId;
claimSkuDetail.ClaimSkuCategoryId = Convert.ToInt32(DropDownListCategory.SelectedValue);
claimSkuDetail.ClaimSkuSubCategoryId = Convert.ToInt32(DropDownListSubCategory.SelectedValue);
claimSkuDetail.Quantity = Convert.ToInt32(TextBoxQuantity.Text);
claimSkuDetail.AccountId = this.accountId;
claimSkuDetail.ModifiedUser = this.Master.LoggedOnAccount;
try
{
claimSkuDetail.SaveClaimSkuDetail();
HiddenFieldClaimSkuDetailId.Value = "";
//int claimSkuId = claimSkuDetail.ClaimSkuId;
Button clickedButton = (Button)sender;
switch (clickedButton.ID)
{
case "ButtonCategoryNew":
ResetCategory();
BindSkuCategory();
//Response.Redirect(String.Format("ClaimSkuEdit.aspx?StoreId={0}&ClaimSkuId={1}", Convert.ToInt32(DropDownListStore.SelectedValue), claimSku.ClaimSkuId));
break;
}
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
LabelError.Text = "";
for (int i = 0; i < sqlEx.Errors.Count; i++)
{
LabelError.Text += (sqlEx.Errors[i].Message + "<br />");
}
PanelError.Visible = true;
PanelErrorSpace.Visible = true;
}
}
}
private void BindSkuCategory()
{
GridViewResult.DataSource = ClaimSku.GetClaimSkuDetailListByClaimSkuId(this.claimSkuId);
GridViewResult.DataBind();
}
protected void ButtonSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
bool hasError = false;
LabelError.Text = "";
if (DropDownListStore.SelectedValue == "0")
{
LabelError.Text = "Store is required.<br />";
hasError = true;
}
DateTime claimDate;
bool isDate = DateTime.TryParse(TextBoxClaimDate.Text, out claimDate);
if (!isDate)
{
LabelError.Text += "Claim Date is required.<br />";
hasError = true;
}
if ((DateTime.Today - claimDate).Days >= 120)
{
LabelError.Text += "Claim Date cannot be back dated more than 4 months.<br />";
hasError = true;
}
if (TextBoxClaimNumber.Text.Length == 0)
{
LabelError.Text += "Claim Number is required.";
hasError = true;
}
if (hasError == true)
{
PanelError.Visible = true;
PanelErrorSpace.Visible = true;
return;
}
ClaimSku claimSku = new ClaimSku();
claimSku.ClaimSkuId = this.claimSkuId;
claimSku.StoreId = Convert.ToInt32(DropDownListStore.SelectedValue);
claimSku.ClaimDate = Convert.ToDateTime(TextBoxClaimDate.Text);
claimSku.ClaimNumber = (TextBoxClaimNumber.Text.Length > 0) ? TextBoxClaimNumber.Text : "";
claimSku.ModifiedUser = this.Master.LoggedOnAccount;
claimSku.AccountId = this.accountId;
//Supplier Name Change
string supplierNameChange = (DropDownListSupplier.SelectedItem.Text == "Monteagle Dairies(Honeydew)") ? "Honeydew" : DropDownListSupplier.SelectedItem.Text;
claimSku.Supplier = supplierNameChange;
try
{
claimSku.Save();
int claimSkuId = claimSku.ClaimSkuId;
Button clickedButton = (Button)sender;
switch (clickedButton.ID)
{
case "ButtonSaveList":
//Response.Redirect(String.Format("ClaimSkuList.aspx?ClaimSkuId={0}", claimSku.ClaimSkuId));
Response.Redirect(String.Format("ClaimScheduleEdit.aspx?ClaimNumber={0}&ClaimStoreId={1}&ClaimDate={2}&Supplier={3}", claimSku.ClaimNumber, claimSku.StoreId, claimSku.ClaimDate, claimSku.Supplier));
break;
case "ButtonSaveAdd":
Response.Redirect(String.Format("ClaimSkuEdit.aspx?StoreId={0}&ClaimSkuId={1}&CompanyId={2}&Supplier={3}", Convert.ToInt32(DropDownListStore.SelectedValue), claimSku.ClaimSkuId, this.accountId, claimSku.Supplier));
break;
}
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
LabelError.Text = "";
for (int i = 0; i < sqlEx.Errors.Count; i++)
{
LabelError.Text += (sqlEx.Errors[i].Message + "<br />");
}
PanelError.Visible = true;
PanelErrorSpace.Visible = true;
}
}
}
