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); }