/// <summary>
/// Called from PUT
/// </summary>
/// <param name="obj"></param>
/// <param name="returnMessage"></param>
/// <returns></returns>
public bool Update(orders obj, out string returnMessage)
{
returnMessage = string.Empty;
using (var edc = new EDC())
{
edc.Entry(obj).State = System.Data.Entity.EntityState.Modified;
try
{
edc.SaveChanges();
return(true);
}
catch (Exception ex)
{
returnMessage = ex.Message;
return(false);
}
}
}
public static List <orders> GetValidOrder()
{
List <orders> o = new List <orders>();
IDbConnection conn = new MySqlConnection();
conn.ConnectionString = connString;
string query = " select * from orders where ordered_date > curdate() - 10";
IDbCommand cmd = new MySqlCommand();
cmd.CommandText = query;
cmd.Connection = conn;
MySqlDataAdapter da = new MySqlDataAdapter(cmd as MySqlCommand);
DataSet ds = new DataSet();
try
{
//orderid, customerID, cropID, quantity, total_amount
da.Fill(ds);
DataRowCollection rows = ds.Tables[0].Rows;
foreach (DataRow row in rows)
{
orders order = new orders();
order.orderid = int.Parse(row["orderid"].ToString());
order.customerID = int.Parse(row["customerID"].ToString());
order.cropID = int.Parse(row["cropID"].ToString());
order.quantity = int.Parse(row["quantity"].ToString());
order.total_amount = int.Parse(row["total_amount"].ToString());
order.crop_name = row["crop_name"].ToString();
order.address = row["address"].ToString();
order.ordered_date = DateTime.Parse(row["ordered_date"].ToString());
o.Add(order);
}
}
catch (MySqlException e)
{
string message = e.Message;
}
// implementation
return(o);
}
/// <summary>
/// Called from DELETE
/// </summary>
/// <param name="obj"></param>
/// <param name="returnMessage"></param>
/// <returns></returns>
public bool Delete(string id, out string returnMessage)
{
returnMessage = string.Empty;
using (var edc = new EDC())
{
orders obj = Get(id);
edc.Entry(obj).State = System.Data.Entity.EntityState.Deleted;
try
{
edc.SaveChanges();
return(true);
}
catch (Exception ex)
{
returnMessage = ex.Message;
return(false);
}
}
}
/// <summary>
/// Called from POST
/// </summary>
/// <param name="obj"></param>
/// <param name="returnMessage"></param>
/// <returns></returns>
public bool Create(orders obj, out string returnMessage)
{
Guid id = Guid.NewGuid();
obj.id = id.ToString();
returnMessage = id.ToString();
using (var edc = new EDC())
{
edc.Orders.Add(obj);
try
{
edc.SaveChanges();
return(true);
}
catch (Exception ex)
{
returnMessage = ex.Message;
return(false);
}
}
}