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