public HttpResponseMessage PutLOVType(int id, LOVType item) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } if (id != item.LOVTypeID) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } db.Entry(item).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex)); } return(Request.CreateResponse(HttpStatusCode.OK)); }
// GET api/LOVType/5 public LOVType GetLOVType(int id) { var items = db.LOVTypes.Include(p => p.LOVs); LOVType item = items.Where(p => p.LOVTypeID == id).FirstOrDefault(); if (item == null) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound)); } return(item); }
public HttpResponseMessage PostLOVType(LOVType item) { if (ModelState.IsValid) { db.LOVTypes.Add(item); db.SaveChanges(); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, item); response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = item.LOVTypeID })); return(response); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } }
public HttpResponseMessage DeleteLOVType(int id) { LOVType item = db.LOVTypes.Find(id); if (item == null) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } db.LOVTypes.Remove(item); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex)); } return(Request.CreateResponse(HttpStatusCode.OK, item)); }
static void Main(string[] args) { string dobString = "May 23 1988 12:00AM"; DateTime dobDt; smART.Common.DateTimeHelper.IsValidDate(dobString, out dobDt); //try //{ // Exception ex = new DataException("ABC"); // HandleException(ref ex); //} //catch (Exception ex) //{ // Console.WriteLine(ex.Message); // Console.ReadLine(); //} //StringBuilder sb = new StringBuilder(); //List<Item> Customers = new List<Item>(); //Customers.Add(new Item() { // ID = 1, Short_Name = "sanjeev", Item_Category = "A",Created_Date = DateTime .Now //}); //Customers.Add(new Item() { // ID = 2, Short_Name = "nitin", Item_Category = "b", Created_Date = DateTime.Now //}); //Customers.Add(new Item() { // ID = 3, Short_Name = "manish", Item_Category = "b", Created_Date = DateTime.Now //}); //Customers.Add(new Item() { // ID = 4, Short_Name = "bhopu", Item_Category = "d", Created_Date = DateTime.Now //}); //sb.AppendFormat("{0,-8}{1,-20}{2,-15}{3,-10:yyyyMMdd}{4}", // "ID".PadLeft(6, '0'), // "Short_Name", // "Item_Category", // "Created Date", // Environment.NewLine); //sb.AppendFormat("===================================================="); //sb.AppendFormat(Environment.NewLine); //foreach (Item c in Customers) { // sb.AppendFormat("{0,-8}{1,-20}{2,-15}{3,-10:yyyyMMdd}{4}", // c.ID.ToString().PadLeft(6, '0'), // c.Short_Name, // c.Item_Category, // c.Created_Date, // Environment.NewLine); //} // sb.AppendFormat("===================================================="); // Sanjeev string strConnectionString = ConfigurationManager.ConnectionStrings["smARTDBContext"].ConnectionString; Database.SetInitializer <smARTDBContext>(new smARTDbContextInitializer()); smARTDBContext dbContext = new Model.smARTDBContext(strConnectionString); LOVType lovType = dbContext.M_LOV.SingleOrDefault(o => o.LOVType_Name == "PARTY_TYPE"); //IQueryable<LOVType> lovTypes = dbContext.M_LOV.Where(Lambda("LOVType_Name", "Party")); }