public async Task SaveData(Data_Category data)
{
if (data.Id.IsNullOrEmpty())
{
data.InitEntity();
await _data_CategoryBus.AddDataAsync(data);
}
else
{
await _data_CategoryBus.UpdateDataAsync(data);
}
}
public List <Data_Category> SearchCategory(int CategoryID, string CategoryDesc, int?IsActive)
{
List <Data_Category> categories = new List <Data_Category>();
SqlConnection sqlConn = new SqlConnection(base.Connection.ConnectionString);
using (sqlConn)
{
try
{
int ia = (IsActive == null) ? 0 : Convert.ToInt32(IsActive);
SqlCommand cmd = sqlConn.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "dbo.Search_Category";
cmd.Parameters.AddWithValue("@CategoryID", CategoryID);
cmd.Parameters.AddWithValue("@CategoryDesc", CategoryDesc);
cmd.Parameters.AddWithValue("@Isactive", ia);
if (sqlConn.State != ConnectionState.Open)
{
sqlConn.Open();
}
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Data_Category category = new Data_Category()
{
CategoryID = (rdr["CategoryID"].ToString() == string.Empty) ? 0 : Convert.ToInt32(rdr["CategoryID"].ToString()),
CategoryDesc = rdr["CategoryDesc"].ToString(),
IsActive = (rdr["IsActive"].ToString() == string.Empty) ? 0 : Convert.ToInt32(rdr["IsActive"].ToString()),
};
categories.Add(category);
}
rdr.Close();
}
catch (Exception ex)
{
throw ex;
}
}
return(categories);
}
public List<Data_Category> SearchCategory(int CategoryID, string CategoryDesc, int? IsActive)
{
List<Data_Category> categories = new List<Data_Category>();
SqlConnection sqlConn = new SqlConnection(base.Connection.ConnectionString);
using (sqlConn)
{
try
{
int ia = (IsActive == null) ? 0 : Convert.ToInt32(IsActive);
SqlCommand cmd = sqlConn.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "dbo.Search_Category";
cmd.Parameters.AddWithValue("@CategoryID", CategoryID);
cmd.Parameters.AddWithValue("@CategoryDesc", CategoryDesc);
cmd.Parameters.AddWithValue("@Isactive", ia);
if (sqlConn.State != ConnectionState.Open)
sqlConn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Data_Category category = new Data_Category()
{
CategoryID = (rdr["CategoryID"].ToString() == string.Empty) ? 0 : Convert.ToInt32(rdr["CategoryID"].ToString()),
CategoryDesc = rdr["CategoryDesc"].ToString(),
IsActive = (rdr["IsActive"].ToString() == string.Empty) ? 0 : Convert.ToInt32(rdr["IsActive"].ToString()),
};
categories.Add(category);
}
rdr.Close();
}
catch (Exception ex)
{
throw ex;
}
}
return categories;
}
