public List<WaldenCompleteFaxWeb.Models.FaxToInformation> GetFaxToInformation(string id)
{
List<WaldenCompleteFaxWeb.Models.FaxToInformation> faxToList = new List<WaldenCompleteFaxWeb.Models.FaxToInformation>();
WaldenCompleteFaxWeb.Models.FaxToInformation faxTo;
try
{
using (var ctx = ConnectionManager<SqlConnection>.GetManager(Database.WaldenFax, false))
{
using (var cm = ctx.Connection.CreateCommand())
{
cm.CommandText = "SELECT [SendFaxID],[AccountID],[FirstName],[LastName]"
+ " ,[Name],[FaxNumber]"
+ " FROM [FaxSendingInformation]"
+ " where SendFaxID = " + id;
cm.CommandType = System.Data.CommandType.Text;
//cm.Parameters.AddWithValue("@UserID",Environment.UserName);
using (var dr = new SafeDataReader(cm.ExecuteReader()))
{
while (dr.Read())
{
faxTo = new WaldenCompleteFaxWeb.Models.FaxToInformation();
try
{
faxTo.ID = int.Parse(dr["SendFaxID"].ToString());
}
catch
{
faxTo.ID = 1;
}
try
{
faxTo.FirstName = dr["FirstName"].ToString();
}
catch
{
faxTo.FirstName = string.Empty;
}
try
{
faxTo.LastName = dr["LastName"].ToString();
}
catch
{
faxTo.LastName = string.Empty;
}
try
{
faxTo.Name = dr["Name"].ToString();
}
catch
{
faxTo.Name = string.Empty;
}
try
{
faxTo.FaxNumber = dr["FaxNumber"].ToString();
}
catch
{
faxTo.FaxNumber = string.Empty;
}
faxToList.Add(faxTo);
}
}
}
}
return faxToList;
}
catch (Exception er)
{
Walden.CompleteFax.Library.Database.Log(er.Message);
return faxToList;
}
}
//// GET api/customer/5
//public string Get()
////public FaxFromName Get()
//{
// return "DD";
// //return faxing.GetFromName();
//}
// POST api/fromname
//public void Post([FromBody]Customer customer)
//public IHttpActionResult Post(FaxFromName fromName)
//{
// faxing.UpdateFromName(fromName.FromName);
// return Ok();
//}
public IHttpActionResult Post(FaxToInformation faxToInformation)
{
faxing.AddSendTo(faxToInformation);
//faxing.UpdateFromName(fromName.FromName);
return Ok();
}
