private static MenuEntity InsertUpdate(MenuEntity menuEntity, DatabaseAccessKey databaseAccessKey) { try { using (SqlCommand command = new SqlCommand()) { command.CommandText = "MenuMasterAction"; command.CommandType = CommandType.StoredProcedure; SqlParameter MenuId = new SqlParameter("@MenuId", menuEntity.Id); command.Parameters.Add(MenuId); SqlParameter CuisineId = new SqlParameter("@CuisineId", menuEntity.Cuisine.Id); command.Parameters.Add(CuisineId); SqlParameter CourseId = new SqlParameter("@CourseId", menuEntity.Course.Id); command.Parameters.Add(CourseId); SqlParameter MenuName = new SqlParameter("@MenuName", menuEntity.Name); command.Parameters.Add(MenuName); SqlParameter ShortContent = new SqlParameter("@ShortContent", menuEntity.Description.LongContent); command.Parameters.Add(ShortContent); SqlParameter Title = new SqlParameter("@Title", menuEntity.Description.Title); command.Parameters.Add(Title); SqlParameter LongContent = new SqlParameter("@LongContent", menuEntity.Description.LongContent); command.Parameters.Add(LongContent); SqlParameter User = new SqlParameter("@User", menuEntity.CreatedByUserName); command.Parameters.Add(User); SqlParameter DescriptionId = new SqlParameter("@DescriptionId", menuEntity.Description.Id); command.Parameters.Add(DescriptionId); SqlParameter IsActive = new SqlParameter("@IsActive", menuEntity.IsActive); command.Parameters.Add(IsActive); SqlParameter ActionMode = new SqlParameter("@ActionMode", databaseAccessKey); command.Parameters.Add(ActionMode); using (DataTable dt = DataAccess.GetData(command)) { foreach (DataRow dr in dt.Rows) { menuEntity.Id = DataConvert.ToInt(dr["MenuId"]); } } } } catch (Exception ex) { throw ex; } return(menuEntity); }
private static RegisterEntity InsertUpdate(RegisterEntity registerEntity, DatabaseAccessKey databaseAccessKey) { try { using (SqlCommand command = new SqlCommand()) { command.CommandText = "RegisterMasterAction"; command.CommandType = CommandType.StoredProcedure; SqlParameter RegisterName = new SqlParameter("@RegisterName", registerEntity.Name); command.Parameters.Add(RegisterName); SqlParameter RegisterEmail = new SqlParameter("@RegisterEmail", registerEntity.Email); command.Parameters.Add(RegisterEmail); SqlParameter User = new SqlParameter("@User", registerEntity.CreatedByUserId); command.Parameters.Add(User); SqlParameter IsActive = new SqlParameter("@IsActive", registerEntity.IsActive); command.Parameters.Add(IsActive); SqlParameter RegisterId = new SqlParameter("@RegisterId", registerEntity.Id); command.Parameters.Add(RegisterId); SqlParameter ActionMode = new SqlParameter("@ActionMode", databaseAccessKey); command.Parameters.Add(ActionMode); using (DataTable dt = DataAccess.GetData(command)) { foreach (DataRow dr in dt.Rows) { registerEntity.Id = DataConvert.ToInt(dr["Id"]); } } } } catch (Exception ex) { throw ex; } return(registerEntity); }