public IHttpActionResult CreatePlanAdd(PlanAddDto planAdd) { JsonObject json = new JsonObject(); GradeVersionDAL gradeVersion = new GradeVersionDAL(); string version = gradeVersion.CheckGradeVersion(planAdd.SampleName, planAdd.LOT_NO); if (string.IsNullOrEmpty(version)) { json["Error"] = "Grade Version is NULL"; return(Ok(json)); } planAdd.GradeVersion = new Guid(version); try { DOCPlanAdd sd = JsonConvert.DeserializeObject <DOCPlanAdd>(JsonConvert.SerializeObject(planAdd));; if (!draftDAL.CreatePlanAdd(sd)) { json["Error"] = "Can not Save Plan Add"; return(Ok(json)); } else { json["Success"] = "Success"; return(Ok(json)); } } catch (Exception ex) { Console.WriteLine(ex); Loger.Error(ex); return(BadRequest(ex.Message + "-" + ex.StackTrace)); } }
/// <summary> /// add Plan project Create /// </summary> /// <param name="DOC"></param> /// <returns></returns> public bool InsertPlanAdd(DOCPlanAdd DOC) { Console.WriteLine("PlanAddService-InsertPlanAdd():" + DateTime.Now); //Get Currrent User try { DataTable dt = acQC.ExecuteStoredProcedure("i_CheckGrade_Version", new string[] { "UserID", "SampleName", "LOT_NO" }, new object[] { "", DOC.SampleName, DOC.LOT_NO }).Tables[0]; string msg = string.Empty; msg = dt.Rows[0]["MSG"].ToString(); if (!string.IsNullOrEmpty(msg)) { throw new Exception(msg); } DOC.GradeVersion = new Guid(dt.Rows[0]["VersionID"].ToString()); DOC.ProdDate = System.DateTime.Now; DOC.State = "0"; DOC.UserID = DB.User; log.Info(JsonConvert.SerializeObject(DOC)); return(db.Insert(DOC)); } catch (Exception e) { log.Error(e); throw e; } }
/// <summary> /// create plan ,other add test project /// </summary> /// <param name="planAdd"></param> /// <returns></returns> public bool CreatePlanAdd(DOCPlanAdd planAdd) { try { return(db.Insert(planAdd)); } catch (Exception e) { log.Error(e); throw new Exception(e.Message); } }
public bool CreatePlanAdd(DOCPlanAdd planadd) { Console.WriteLine("PlanAddDAL - CreatePlanAdd():" + DateTime.Now.ToString()); try { return(db.Insert(planadd)); } catch (Exception e) { log.Error(e); throw new Exception(e.Message); } }
public bool InsertPlanAdd(DOCPlanAdd DOC) { return(proxy.InsertPlanAdd(DOC)); }