private void save()
{
DECustomerCategory catagory = new DECustomerCategory();
AssignData(catagory);
BLLCustomerCategory obj_BLLCatagory = new BLLCustomerCategory();
try
{
int int_Result = obj_BLLCatagory.InsertData(catagory);
if (int_Result > 0)
{
MessageBox.Show(UIConstantMessage.Const_strSaveSuccessfully);
BindDataGridView();
clearScreen();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
catagory = null;
obj_BLLCatagory = null;
}
}
private SqlCommand DeclareSqlCmdParameter(SqlCommand SqlCmd, DECustomerCategory catagory)
{
SqlCmd.Parameters.AddWithValue("@Catagory_Id", catagory.Catagory_Id);
SqlCmd.Parameters.AddWithValue("@Catagory_Description", catagory.Catagory_Description);
SqlCmd.Parameters.AddWithValue("@Active", catagory.Active);
SqlCmd.Parameters.AddWithValue("@ModifiedBy", catagory.ModifiedBy);
SqlCmd.Parameters.AddWithValue("@ModifiedDate", catagory.ModifiedDate);
return(SqlCmd);
}
public DataTable LoadCatagoryTableForAllDataByCatagoryDescription(DECustomerCategory catagory)
{
DALCustomerCategory obj_DALCatagory = new DALCustomerCategory();
DataTable dt_Catagory = obj_DALCatagory.LoadCatagoryTableForAllDataByCatagoryDescription(catagory);
obj_DALCatagory = null;
return(dt_Catagory);
}
public int DeleteData(DECustomerCategory catagory)
{
DALCustomerCategory obj_DALCatagory = new DALCustomerCategory();
int int_Result = obj_DALCatagory.DeleteData(catagory);
obj_DALCatagory = null;
return(int_Result);
}
public Boolean LoadCatagoryRow(DECustomerCategory catagory)
{
DALCustomerCategory obj_DALCatagory = new DALCustomerCategory();
Boolean bool_HasRows = obj_DALCatagory.LoadCatagoryRow(catagory);
obj_DALCatagory = null;
return(bool_HasRows);
}
public int UpdateData(DECustomerCategory catagory)
{
int int_Result;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "UPDATE tbl_CustomerCatagory SET Catagory_Id= @Catagory_Id, Catagory_Description=@Catagory_Description, Active = @Active ,ModifiedBy = @ModifiedBy ,ModifiedDate = @ModifiedDate WHERE Catagory_Id = @Catagory_Id";
DeclareSqlCmdParameter(sqlCmd, catagory);
int_Result = SqlConjunction.GetSQLVoid(sqlCmd);
sqlCmd = null;
return(int_Result);
}
public int InsertData(DECustomerCategory catagory)
{
int int_Result;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "SELECT @Catagory_Id = ISNULL(MAX(Catagory_Id),0)+1 FROM tbl_CustomerCatagory INSERT tbl_CustomerCatagory VALUES(@Catagory_Id,@Catagory_Description,@Active,@ModifiedBy,@ModifiedDate)";
DeclareSqlCmdParameter(sqlCmd, catagory);
int_Result = SqlConjunction.GetSQLVoid(sqlCmd);
sqlCmd = null;
return(int_Result);
}
public DataTable LoadCatagoryTableForAllDataByCatagoryDescription(DECustomerCategory catagory)
{
DataTable dt_Catagory;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "SELECT 0 As 'No',Cat.Catagory_Id,Cat.Catagory_Description,Cat.Active,Cat.ModifiedBy,Cat.ModifiedDate FROM tbl_CustomerCatagory Cat where Cat.Active = 'true' And Cat.Catagory_Description LIKE '%' + @Catagory_Description+ '%' order by Cat.Catagory_Description";
sqlCmd = DeclareSqlCmdParameter(sqlCmd, catagory);
dt_Catagory = SqlConjunction.GetSQLDataTable(sqlCmd);
sqlCmd = null;
return(dt_Catagory);
}
public int DeleteData(DECustomerCategory catagory)
{
int int_Result;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "DELETE FROM tbl_CustomerCatagory WHERE Catagory_ID = @Catagory_Id";
DeclareSqlCmdParameter(sqlCmd, catagory);
int_Result = SqlConjunction.GetSQLVoid(sqlCmd);
sqlCmd = null;
return(int_Result);
}
public int InsertData(DECustomerCategory catagory)
{
DALCustomerCategory obj_DALCatagory = new DALCustomerCategory();
int int_Result;
if (catagory.Catagory_Id == 0)
{
int_Result = obj_DALCatagory.InsertData(catagory);
}
else
{
int_Result = obj_DALCatagory.UpdateData(catagory);
}
obj_DALCatagory = null;
return(int_Result);
}
private void dgv_Catagory_DoubleClick(object sender, EventArgs e)
{
DECustomerCategory catagory = new DECustomerCategory();
catagory.Catagory_Id = Convert.ToInt32(dgv_Catagory.CurrentRow.Cells[1].Value);
BLLCustomerCategory obj_BLLCatagory = new BLLCustomerCategory();
bool bool_Result = obj_BLLCatagory.LoadCatagoryRow(catagory);
if (bool_Result == true)
{
DisplayData(catagory);
}
else
{
MessageBox.Show("Record is not found.");
}
catagory = null;
obj_BLLCatagory = null;
}
public Boolean LoadCatagoryRow(DECustomerCategory catagory)
{
Boolean bool_HasRows = false;
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "SELECT Catagory_Id,Catagory_Description,Active,ModifiedBy,ModifiedDate FROM tbl_CustomerCatagory Where Catagory_Id=@Catagory_Id";
sqlCmd = DeclareSqlCmdParameter(sqlCmd, catagory);
SqlConnection con = new SqlConnection(SqlConjunction.DataConn);
SqlDataReader sqlDataReader = SqlConjunction.GetSQLExecuteReader(sqlCmd, con);
while (sqlDataReader.Read())
{
catagory.Catagory_Id = sqlDataReader.GetInt32(0);
catagory.Catagory_Description = sqlDataReader.GetString(1);
catagory.Active = sqlDataReader.GetBoolean(2);
catagory.ModifiedBy = sqlDataReader.GetString(3);
catagory.ModifiedDate = sqlDataReader.GetDateTime(4);
}
if (sqlDataReader.HasRows)
{
bool_HasRows = true;
}
else
{
bool_HasRows = false;
}
con.Close();
sqlCmd = null;
return(bool_HasRows);
}
private void BindDataGridView()
{
DECustomerCategory catagory = new DECustomerCategory();
BLLCustomerCategory obj_BLLCatagory = new BLLCustomerCategory();
DataTable dt_Catagory;
if (txt_FilteredDescription.Text.Trim().Length <= 0)
{
dt_Catagory = obj_BLLCatagory.LoadCatagoryTableForAllData();
}
else
{
catagory.Catagory_Description = txt_FilteredDescription.Text;
dt_Catagory = obj_BLLCatagory.LoadCatagoryTableForAllDataByCatagoryDescription(catagory);
}
dgv_Catagory.DataSource = dt_Catagory;
NumberingTableForDataGridView(dt_Catagory);
FormatDataGridView();
}
private void DisplayData(DECustomerCategory catagory)
{
txt_CatagoryDescription.Tag = catagory.Catagory_Id;
txt_CatagoryDescription.Text = catagory.Catagory_Description;
}
private void AssignData(DECustomerCategory catagory)
{
catagory.Catagory_Id = Convert.ToInt32(txt_CatagoryDescription.Tag);
catagory.Catagory_Description = txt_CatagoryDescription.Text.Trim();
catagory.ModifiedBy = DEGlobal.str_UserName;
}
