public void Update(MasterMenuView model)
{
using (var ctx = new ConXContext())
{
using (TransactionScope scope = new TransactionScope())
{
string strConn = ConfigurationManager.ConnectionStrings["OracleDbContext"].ConnectionString;
var dataConn = new OracleConnectionStringBuilder(strConn);
OracleConnection conn = new OracleConnection(dataConn.ToString());
conn.Open();
OracleCommand oraCommand = conn.CreateCommand();
OracleParameter[] param = new OracleParameter[]
{
new OracleParameter("p_menu_id", model.menuFunctionId),
new OracleParameter("p_menu_name", model.menuFunctionName),
new OracleParameter("p_main_menu", model.menuFunctionGroupId),
new OracleParameter("p_link_name", model.menuURL),
new OracleParameter("p_icon_name", model.iconName),
};
oraCommand.BindByName = true;
oraCommand.Parameters.AddRange(param);
oraCommand.CommandText = "update su_menu set menu_name = :p_menu_name , main_menu =:p_main_menu , link_name = :p_link_name , icon_name =:p_icon_name where menu_id = :p_menu_id";
oraCommand.ExecuteNonQuery();
conn.Close();
scope.Complete();
}
}
}
public void Update(MasterMenuView model)
{
using (var ctx = new ConXContext())
{
using (TransactionScope scope = new TransactionScope())
{
MenuFunction updateObj = ctx.MenuFunctions.Where(z => z.menuFunctionId == model.menuFunctionId).SingleOrDefault();
updateObj.menuFunctionId = model.menuFunctionId;
updateObj.menuFunctionGroupId = model.menuFunctionGroupId;
updateObj.menuFunctionName = model.menuFunctionName;
updateObj.menuURL = model.menuURL;
updateObj.iconName = model.iconName;
updateObj.orderDisplay = model.orderDisplay;
ctx.SaveChanges();
scope.Complete();
}
}
}
public HttpResponseMessage postUpdate(MasterMenuView model)
{
try
{
//check dupplicate Code
//var isDupplicate = menuGroupSvc.CheckDupplicate(model.menuFunctionGroupId);
//if (isDupplicate)
//{
// return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, string.Format("รหัสกลุ่มเมนู {0} มีอยู่ในระบบแล้ว", model.menuFunctionGroupId));
//}
menuSvc.Update(model);
return(Request.CreateResponse(HttpStatusCode.OK, "บันทึกข้อมูลสำเร็จ"));
}
catch (Exception ex)
{
return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.ToString()));
}
}
public void Create(MasterMenuView model)
{
using (var ctx = new ConXContext())
{
using (TransactionScope scope = new TransactionScope())
{
MenuFunction newObj = new MenuFunction()
{
menuFunctionId = model.menuFunctionId,
menuFunctionGroupId = model.menuFunctionGroupId,
menuFunctionName = model.menuFunctionName,
menuURL = model.menuURL,
iconName = model.iconName,
orderDisplay = model.orderDisplay
};
ctx.MenuFunctions.Add(newObj);
ctx.SaveChanges();
scope.Complete();
}
}
}
