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