public CategoryViewModel CategoryList(int UserId, int TypeId, int CategoryId)
{
CategoryViewModel returnModel = new CategoryViewModel();
returnModel.category = new CategoryModel();
DataTable resultDT = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
UserId = 1;
string cnnString = CommonHelper.GetConnectionString();
using (SqlConnection cnn = new SqlConnection(cnnString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "usp_CategoryList";
//------add any parameters the stored procedure might require------------------//
cmd.Parameters.AddWithValue("UserID", UserId);
cmd.Parameters.AddWithValue("TypeID", TypeId);
cnn.Open();
da.SelectCommand = cmd;
da.Fill(resultDT);
}
returnModel.SelectedTypeName = resultDT.Rows[0].Field <string>("TypeName");
returnModel.SelectedTypeId = resultDT.Rows[0].Field <int>("TypeId");
returnModel.CategoryMList = ObjectRelationMap.ConvertToList <CategoryModel>(resultDT);
returnModel.category.TypeId = returnModel.SelectedTypeId;
return(returnModel);
}
public CategoryViewModel TypeMasterList(int UserId)
{
CategoryViewModel returnModel = new CategoryViewModel();
DataTable resultDT = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
UserId = 1;
string cnnString = CommonHelper.GetConnectionString();
using (SqlConnection cnn = new SqlConnection(cnnString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = cnn;
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "usp_TypeMasterList";
//------add any parameters the stored procedure might require------------------//
cmd.Parameters.AddWithValue("UserID", UserId);
cnn.Open();
da.SelectCommand = cmd;
da.Fill(resultDT);
}
returnModel.TypeList = ObjectRelationMap.ConvertToList <TypeModel>(resultDT);
return(returnModel);
}
