public List <BOSecondCategory> selectSecondCatelist(BOSecondCategory _boseccat)
{
SqlCommand _sqlcommand;
SqlDataAdapter _sqlDataAdapter;
using (SqlConnection _con = ConnectionInfo.GetConnection())
{
_sqlcommand = new SqlCommand();
_sqlcommand.CommandText = "SP_GetSecondCategory";
_sqlcommand.CommandType = System.Data.CommandType.StoredProcedure;
_sqlcommand.Connection = _con;
_con.Open();
_sqlcommand.Parameters.AddWithValue("@Event", _boseccat.Event);
_sqlDataAdapter = new SqlDataAdapter(_sqlcommand);
DataTable _dataTable = new DataTable();
_sqlDataAdapter.Fill(_dataTable);
List <BOSecondCategory> _merfr = (from cu in _dataTable.AsEnumerable()
select new BOSecondCategory
{
SecondCategoryId = cu.Field <int>("SecondCategoryId"),
SecondCategoryName = cu.Field <string>("SecondCategoryName")
}).ToList();
return(_merfr);
}
}
protected void btnRequest_Click(object sender, EventArgs e)
{
try
{
if (Session["CheckRefresh"].ToString() == ViewState["CheckRefresh"].ToString())
{
Session["CheckRefresh"] = Server.UrlDecode(System.DateTime.Now.ToString());
BOSecondCategory _boscat = new BOSecondCategory();
BASecondCategory _bascat = new BASecondCategory();
_boscat.SecondCategoryName = txtcategory.Text;
_boscat.TopCategoryId = Convert.ToInt32(drpTopcategory.SelectedValue);
_boscat.IsActive = false;
_boscat.IsDelete = false;
_boscat.CreatedBy = merchantId;
_boscat.CreatedDate = DateTime.UtcNow;
_boscat.UpdatedBy = merchantId;
_boscat.UpdatedDate = DateTime.UtcNow;
_boscat.Event = "Insert";
int result = _bascat.Insert(_boscat);
if (result == 1)
{
ShowMessage("Category added successfully", MessageType.Success);
}
}
}
catch (Exception ex)
{
Common.LogError(ex);
ShowMessage("Some technical error", MessageType.Warning);
}
txtcategory.Text = "";
}
private void FillSecondCategory()
{
BOSecondCategory _boseccat = new BOSecondCategory();
_boseccat.Event = "GETALL";
List <BOSecondCategory> _secCatlist = bascat.SelectSecondCategoryList(_boseccat);
cmbSecondCategory.DataSource = _secCatlist;
cmbSecondCategory.DisplayMember = "SecondCategoryName";
cmbSecondCategory.ValueMember = "SecondCategoryId";
}
private void FillSecondCategoryCombo(string eventtxt, int topcatid)
{
BOSecondCategory _boseccat = new BOSecondCategory();
BASecondCategory bascat = new BALayer.BASecondCategory();
List <BOSecondCategory> _secCatlist = bascat.SelectSecondCatListWithTop(eventtxt, topcatid);
cmbSecondcat.DataSource = null;
if (_secCatlist.Count > 0)
{
cmbSecondcat.DataSource = _secCatlist;
cmbSecondcat.DisplayMember = "SecondCategoryName";
cmbSecondcat.ValueMember = "SecondCategoryId";
}
}
public List <BOSecondCategory> SelectSecondCategoryList(BOSecondCategory secat)
{
DataTable _ta = new DataTable();
_ta = SelectSecondCategory(secat);
List <BOSecondCategory> _scatlist = (from sc in _ta.AsEnumerable()
select new BOSecondCategory
{
SecondCategoryId = sc.Field <int>("SecondCategoryId"),
SecondCategoryName = sc.Field <string>("SecondCategoryName"),
TopCategoryId = sc.Field <int>("TopCategoryId"),
TopCategoryName = sc.Field <string>("TopCategoryName")
}).ToList();
return(_scatlist);
}
public int IUDSecondCategory(BOSecondCategory secat)
{
int returnvalue = default(int);
SqlCommand _sqlcommand;
using (SqlConnection _sqlconnection = ConnectionInfo.GetConnection())
{
_sqlcommand = new SqlCommand();
_sqlcommand.Connection = _sqlconnection;
_sqlcommand.CommandText = "SP_IUDSecondCategory";
_sqlcommand.CommandType = CommandType.StoredProcedure;
_sqlconnection.Open();
_sqlcommand.Parameters.AddWithValue("@SecondCategoryId", secat.SecondCategoryId);
_sqlcommand.Parameters.AddWithValue("@SecondCategoryName", secat.SecondCategoryName);
_sqlcommand.Parameters.AddWithValue("@TopCategoryId", secat.TopCategoryId);
_sqlcommand.Parameters.AddWithValue("@IsActive", secat.IsActive);
_sqlcommand.Parameters.AddWithValue("@IsDelete", secat.IsDelete);
_sqlcommand.Parameters.AddWithValue("@CreatedBy", secat.CreatedBy);
_sqlcommand.Parameters.AddWithValue("@CreatedDate", secat.CreatedDate);
_sqlcommand.Parameters.AddWithValue("@UpdatedBy", secat.UpdatedBy);
_sqlcommand.Parameters.AddWithValue("@UpdatedDate", secat.UpdatedDate);
_sqlcommand.Parameters.AddWithValue("@Event", secat.Event);
_sqlcommand.Parameters.AddWithValue("@returnValue", 0).Direction = System.Data.ParameterDirection.InputOutput;
try
{
_sqlcommand.ExecuteNonQuery();
returnvalue = Convert.ToInt32(_sqlcommand.Parameters["@returnValue"].Value);
}
catch
{
returnvalue = 100;
}
finally
{
_sqlconnection.Close();
_sqlcommand.Dispose();
}
}
return(returnvalue);
}
private void dgvSecondCategory_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (headval)
{
if (dgvSecondCategory.Columns[e.ColumnIndex].Name == "Edit")
{
SecCatId = Convert.ToInt32(dgvSecondCategory.Rows[e.RowIndex].Cells[0].Value.ToString());
txtSecondCategory.Text = dgvSecondCategory.Rows[e.RowIndex].Cells[1].Value.ToString();
cmbTopCategory.Text = dgvSecondCategory.Rows[e.RowIndex].Cells[2].Value.ToString();
btnAdd.Text = "Update";
}
else if (dgvSecondCategory.Columns[e.ColumnIndex].Name == "Delete")
{
DialogResult result1 = MessageBox.Show("Are you sure you want to delete\nrecord " + dgvSecondCategory.Rows[e.RowIndex].Cells[1].Value.ToString() + " ?", "Warning", MessageBoxButtons.YesNo);
if (result1 == DialogResult.Yes)
{
SecCatId = Convert.ToInt32(dgvSecondCategory.Rows[e.RowIndex].Cells[0].Value.ToString());
BOSecondCategory _boscat = new BOSecondCategory();
_boscat.SecondCategoryId = SecCatId;
_boscat.SecondCategoryName = txtSecondCategory.Text;
_boscat.TopCategoryId = Convert.ToInt32(cmbTopCategory.SelectedValue);
_boscat.IsActive = true;
_boscat.IsDelete = true;
_boscat.CreatedBy = loginID;
_boscat.CreatedDate = DateTime.UtcNow;
_boscat.UpdatedBy = loginID;
_boscat.UpdatedDate = DateTime.UtcNow;
_boscat.Event = "Delete";
MessageBox.Show(Common.Message(dgvSecondCategory.Rows[e.RowIndex].Cells[1].Value.ToString(), bscat.Delete(_boscat)));
ClearControl();
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public DataTable SelectSecondCategory(BOSecondCategory secat)
{
SqlCommand _sqlcommand;
SqlDataAdapter _sqlDataAdapter;
using (SqlConnection _con = ConnectionInfo.GetConnection())
{
_sqlcommand = new SqlCommand();
_sqlcommand.CommandText = "SP_GetSecondCategory";
_sqlcommand.CommandType = System.Data.CommandType.StoredProcedure;
_sqlcommand.Connection = _con;
_con.Open();
_sqlcommand.Parameters.AddWithValue("@Event", secat.Event);
_sqlDataAdapter = new SqlDataAdapter(_sqlcommand);
DataTable _dataTable = new DataTable();
_sqlDataAdapter.Fill(_dataTable);
_con.Close();
return(_dataTable);
}
}
public List <BOSecondCategory> SelectSecondCategoryList(BOSecondCategory _boseccat)
{
return(_dascecat.selectSecondCatelist(_boseccat));
}
public List <BOSecondCategory> SelectSecondCategoryList(BOSecondCategory _boscat)
{
return(dascat.SelectSecondCategoryList(_boscat));
}
public int Delete(BOSecondCategory _boscat)
{
return(dascat.IUDSecondCategory(_boscat));
}
public int Insert(BOSecondCategory _boscat)
{
return(dascat.IUDSecondCategory(_boscat));
}
public DataTable SelectSecondCategory(BOSecondCategory _boscat)
{
return(dascat.SelectSecondCategory(_boscat));
}
public int Update(BOSecondCategory _boscat)
{
return(_dascat.IUDSecondCategory(_boscat));
}
internal int Insert(BOSecondCategory _boscat)
{
return(_daseccat.IUD(_boscat));
}
