protected void GridViewCustomDetail_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{
switch (e.CommandName.ToLower())
{
case "editcustomdetail":
{
ViewState["insightSupplierCustomDetailId"] = Convert.ToInt32(e.CommandArgument);
BindCustomDetail(Convert.ToInt32(e.CommandArgument));
break;
}
case "removecustomdetail":
{
InsightSupplierCustomDetail.DeleteInsightSupplierCustomDetailByInsightSupplierCustomDetailId(Convert.ToInt32(e.CommandArgument));
ViewState["insightSupplierCustomDetailId"] = "0";
BindGridViewCustomDetail();
break;
}
}
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
}
}
private void BindCustomDetail(int customDetailId)
{
InsightSupplierCustomDetail insightSupplierCustomDetail = InsightSupplierCustomDetail.GetInsightSupplierCustomDetailByInsightSupplierCustomDetailId(customDetailId);
this.insightSupplierCustomDetailId = insightSupplierCustomDetail.InsightSupplierCustomDetailId;
this.insightSupplierId = insightSupplierCustomDetail.InsightSupplierId;
DropDownListCustomType.ClearSelection();
DropDownListCustomType.Items.FindByValue(insightSupplierCustomDetail.CustomTypeId.ToString()).Selected = true;
DropDownListCustomFrequency.ClearSelection();
DropDownListCustomFrequency.Items.FindByValue(insightSupplierCustomDetail.CustomFrequencyId.ToString()).Selected = true;
DropDownListCustomResponsibility.ClearSelection();
DropDownListCustomResponsibility.Items.FindByValue(insightSupplierCustomDetail.CustomResponsibilityId.ToString()).Selected = true;
TextBoxDetail.Text = insightSupplierCustomDetail.Detail;
TextBoxSourceFile.Text = insightSupplierCustomDetail.SourceFile;
DropDownListStatus.ClearSelection();
DropDownListStatus.Items.FindByValue(insightSupplierCustomDetail.StatusId.ToString()).Selected = true;
}
private bool SaveInsightSupplierCustomDetail()
{
bool hasError = false;
bool hasEntry = false;
bool returnValue = true;
LabelError.Text = "";
PanelError.Visible = false;
if (DropDownListCustomType.SelectedValue == "0")
{
LabelError.Text += " Type is required.";
hasError = true;
}
else
{
hasEntry = true;
}
if (DropDownListCustomFrequency.SelectedValue == "0")
{
LabelError.Text += " Frequency is required.";
hasError = true;
}
else
{
hasEntry = true;
}
if (DropDownListCustomResponsibility.SelectedValue == "0")
{
LabelError.Text += " Responsibility is required.";
hasError = true;
}
else
{
hasEntry = true;
}
if (TextBoxDetail.Text.Length == 0)
{
LabelError.Text += " Detail is required.";
hasError = true;
}
else
{
hasEntry = true;
}
if (TextBoxSourceFile.Text.Length == 0)
{
LabelError.Text += " Source File is required.";
hasError = true;
}
else
{
hasEntry = true;
}
if (hasEntry == true)
{
LabelError.Text += " Please complete all required fields.";
}
if (hasEntry == true)
{
if (hasError == true)
{
PanelError.Visible = true;
return(false);
}
}
InsightSupplierCustomDetail customDetail = new InsightSupplierCustomDetail();
customDetail.InsightSupplierCustomDetailId = (ViewState["insightSupplierCustomDetailId"] == null) ? 0 : Convert.ToInt32(ViewState["insightSupplierCustomDetailId"]);//this.insightSupplierCustomDetailId;
customDetail.InsightSupplierId = this.insightSupplierId;
customDetail.CustomTypeId = Convert.ToInt32(DropDownListCustomType.SelectedValue);
customDetail.CustomFrequencyId = Convert.ToInt32(DropDownListCustomFrequency.SelectedValue);
customDetail.CustomResponsibilityId = Convert.ToInt32(DropDownListCustomResponsibility.SelectedValue);
customDetail.Detail = TextBoxDetail.Text;
customDetail.SourceFile = TextBoxSourceFile.Text;
customDetail.StatusId = Convert.ToInt32(DropDownListStatus.SelectedValue);
customDetail.ModifiedUser = Context.User.Identity.GetUserName();
try
{
customDetail.Save();
BindCustomDetail(customDetail.InsightSupplierCustomDetailId);
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
LabelError.Text = "";
for (int i = 0; i < sqlEx.Errors.Count; i++)
{
ErrorMessage.Text += (sqlEx.Errors[i].Message + "<br />");
//LabelError.Text += (sqlEx.Errors[i].Message + "<br />");
}
returnValue = false;
}
return(returnValue);
}
private void BindGridViewCustomDetail()
{
GridViewCustomDetail.DataSource = InsightSupplierCustomDetail.GetInsightSupplierCustomDetailByInsightSupplierId(this.insightSupplierId);
GridViewCustomDetail.DataBind();
}
