public HttpResponseMessage postSetDefault(DefaultPrinterView model) { try { //check dupplicate Code //var isDupplicate = menuGroupSvc.CheckDupplicate(model.menuFunctionGroupId); //if (isDupplicate) //{ // return Request.CreateErrorResponse(HttpStatusCode.InternalServerError, string.Format("รหัสกลุ่มเมนู {0} มีอยู่ในระบบแล้ว", model.menuFunctionGroupId)); //} printerSvc.SetDefault(model); return(Request.CreateResponse(HttpStatusCode.OK, "บันทึกข้อมูลสำเร็จ")); } catch (Exception ex) { return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.ToString())); } }
public void SetDefault(DefaultPrinterView model) { using (var ctx = new ConXContext()) { using (TransactionScope scope = new TransactionScope()) { // whmobileprnt_default prnt_def = ctx.mobileprnt_def //.Where(z => z.MC_CODE == model.mc_code).SingleOrDefault(); string sqlp = "select series_no from whmobileprnt_default where mc_code = :p_mc_code"; string printer = ctx.Database.SqlQuery <string>(sqlp, new OracleParameter("p_mc_code", model.mc_code)).SingleOrDefault(); if (printer == null) { //whmobileprnt_default newObj = new whmobileprnt_default() //{ // MC_CODE = model.mc_code, // SERIES_NO = model.serial_no, // UPD_BY = model.user_id, // UPD_DATE = DateTime.Now //}; //ctx.mobileprnt_def.Add(newObj); //ctx.SaveChanges(); //scope.Complete(); 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_mc_code", model.mc_code), new OracleParameter("p_series_no", model.serial_no), new OracleParameter("p_upd_by", model.user_id), new OracleParameter("p_upd_date", DateTime.Now), }; oraCommand.BindByName = true; oraCommand.Parameters.AddRange(param); oraCommand.CommandText = "insert into whmobileprnt_default (mc_code , series_no , upd_by , upd_date) values (:p_mc_code , :p_series_no , :p_upd_by , :p_upd_date)"; oraCommand.ExecuteNonQuery(); conn.Close(); scope.Complete(); } else { //whmobileprnt_default updateObj = ctx.mobileprnt_def // .Where(z => z.MC_CODE == model.mc_code).SingleOrDefault(); //updateObj.MC_CODE = model.mc_code; //updateObj.SERIES_NO = model.serial_no; //updateObj.UPD_BY = model.user_id; //updateObj.UPD_DATE = DateTime.Now; //ctx.Configuration.AutoDetectChangesEnabled = true; //ctx.SaveChanges(); //scope.Complete(); 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_mc_code", model.mc_code), new OracleParameter("p_series_no", model.serial_no), new OracleParameter("p_upd_by", model.user_id), new OracleParameter("p_upd_date", DateTime.Now), }; oraCommand.BindByName = true; oraCommand.Parameters.AddRange(param); oraCommand.CommandText = "update whmobileprnt_default set series_no = :p_series_no , upd_by =:p_upd_by , upd_date = :p_upd_date where mc_code = :p_mc_code"; oraCommand.ExecuteNonQuery(); conn.Close(); scope.Complete(); } } } }