/// <summary>
/// To filter details in grid on different conditions selected by user
/// </summary>
/// <param name="DvFilter"></param>
/// <param name="Column"></param>
/// <param name="Operator"></param>
/// <param name="Value"></param>
public void FilterDataview(DataView DvFilter, string Column, string Operator, string Value)
{
DvFilter.RowFilter = Column + " " + Operator + "'" + Value + "'";
if (DvFilter.ToTable().Rows.Count == 0)
{
MsgVen.Msg = "Record(s) not found";
MsgVen.showmsg();
ViewState["DtVen"] = DvFilter.ToTable();
BindVen(DvFilter.ToTable());
ddlCol.SelectedIndex = 0;
ddlOpe.SelectedIndex = 0;
ddlVal.SelectedIndex = 0;
}
else
{
ViewState["DtVen"] = DvFilter.ToTable();
BindVen(DvFilter.ToTable());
}
}
/// <summary>
/// To save Vendor details
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
VendorBAL VendorBAL = new VendorBAL();
int UserID = Convert.ToInt32(ddlVenUser.SelectedValue.ToString());
string Status = ddlVenStatus.SelectedValue.ToString();
bool IsActive = true;
if (Status == "Active")
{
IsActive = true;
}
else if (Status == "InActive")
{
IsActive = false;
}
if (btnSave.Text == "Save")
{
try
{
int Result = VendorBAL.InsertVendor(UserID, IsActive, LoginUser, Ret);
DtVen = VenDetails();
ViewState["DtVen"] = DtVen;
BindVen(DtVen);
MsgVen.Msg = "Record added successfully";
MsgVen.showmsg();
}
catch (Exception ee)
{
if (ee.Message == "Duplicate Entry")
{
MsgVen.Msg = "Duplicate Entry!";
MsgVen.showmsg();
ClearVen();
}
}
finally
{
VendorBAL = null;
}
}
}
