public void setDefault()
{
btnSave.Visible = true;
btnEdit.Visible = false;
txtVariName.Focus();
txtVariName.Text = "";
Ob = SetValue();
grdSearchResult.DataSource = BAL.BALFactory.Instance.BAL_Variation.BindGrid(Ob);
grdSearchResult.DataBind();
}
public DTO.Variation SetValue()
{
Ob = new DTO.Variation();
Ob.VariationName = txtVariName.Text.ToUpper();
Ob.Active = 1;
Ob.DateModified = Globals.date[0].ToString();
Ob.BranchId = Globals.BranchID;
Ob.VariationId = lblvariation.Text;
return(Ob);
}
public string Deletevariation(DTO.Variation Ob)
{
SqlCommand cmd = new SqlCommand();
string res = string.Empty;
cmd.CommandText = "Sp_Variation";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VariationId", Ob.VariationId);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 6);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public DataSet BindGridView(DTO.Variation Ob)
{
SqlCommand cmd = new SqlCommand();
DataSet ds = new DataSet();
cmd.CommandText = "Sp_Variation";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VariationName", Ob.VariationName);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 5);
ds = PrjClass.GetData(cmd);
return(ds);
}
public DataSet BindGrid(DTO.Variation Ob)
{
ArrayList date = DAL.DALFactory.Instance.DAL_DateAndTime.getDateAndTimeAccordingToZoneTime(Ob.BranchId);
DataSet ds = new DataSet();
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Sp_Variation";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 4);
ds = PrjClass.GetData(cmd);
return(ds);
}
public string SaveVariation(DTO.Variation Ob)
{
string res = "";
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "Sp_Variation";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@VariationName", Ob.VariationName);
cmd.Parameters.AddWithValue("@Active", Ob.Active);
cmd.Parameters.AddWithValue("@BranchId", Ob.BranchId);
cmd.Parameters.AddWithValue("@Flag", 1);
res = PrjClass.ExecuteNonQuery(cmd);
return(res);
}
public string SaveVariation(DTO.Variation Ob)
{
return(DAL.DALFactory.Instance.DAL_Variation.SaveVariation(Ob));
}
public string Deletevariation(DTO.Variation Ob)
{
return(DAL.DALFactory.Instance.DAL_Variation.Deletevariation(Ob));
}
public DataSet BindGridView(DTO.Variation Ob)
{
return(DAL.DALFactory.Instance.DAL_Variation.BindGridView(Ob));
}
protected void btnSearch_Click(object sender, EventArgs e)
{
Ob = SetValue();
grdSearchResult.DataSource = BAL.BALFactory.Instance.BAL_Variation.BindGridView(Ob);
grdSearchResult.DataBind();
}