public static int Update(PickupDeliveryAddress a)
{
try
{
a.ModifiedAt = DateTime.UtcNow;
a.ModifiedBy = Environment.UserName;
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
conn.Open();
var result = conn.Query<int>(@"
update invoice.PickupDeliveryAddress
set Location = @Location
,Name = @Name
,Line1 = @Line1
,City = @City
,State = @State
,Zip = @Zip
,ModifiedBy = @ModifiedBy
,ModifiedAt = @ModifiedAt
where PickupDeliveryAddressId = @PickupDeliveryAddressId
", a);
return result.FirstOrDefault();
}
}
catch (Exception ex)
{
logger.Fatal(ex);
return 0;
}
}
public static bool Add(PickupDeliveryAddress a)
{
try {
if (!(GetPickupAndDeliveryLocation(a.Location) == null))
return true;
a.ModifiedAt = a.CreatedAt = DateTime.UtcNow;
a.ModifiedBy = a.CreatedBy = Environment.UserName;
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
conn.Open();
var result = conn.Query<int>(@"
insert into invoice.PickupDeliveryAddress(Location,Name,Line1,City,State,Zip,CreatedBy,CreatedAt,ModifiedBy,ModifiedAt)
values(@Location,@Name,@Line1,@City,@State,@Zip,@CreatedBy,@CreatedAt,@ModifiedBy,@ModifiedAt);
SELECT SCOPE_IDENTITY()", a);
return true;
}
}
catch(Exception ex)
{
logger.Fatal(ex);
return false;
}
}
public ActionResult SaveJobTicket([DataSourceRequest]DataSourceRequest request, string inputJobTicket)
{
if (!User.Identity.IsAuthenticated)
{
return RedirectToAction("Login", "Account");
}
var json_serializer = new JavaScriptSerializer();
JobTicket ticket = json_serializer.Deserialize<JobTicket>(inputJobTicket);
if (lc == null)
lc = lch.GetCompanyRegisteredByUser(User.Identity.Name);
var clientCompany = cch.GetClientCompanyByName(ticket.ClientName, lc);
ticket.ClientCompanyId = clientCompany.ClientCompanyId;
PickupDeliveryAddress addrPickupFrom = new PickupDeliveryAddress(ticket.PickupFrom);
PickupDeliveryAddress addrDeliverTo = new PickupDeliveryAddress(ticket.DeliverTo);
PickupDeliveryAddress.Add(addrPickupFrom);
PickupDeliveryAddress.Add(addrDeliverTo);
if (ticket.JobTicketId == 0)
{
ticket.CreatedBy = User.Identity.Name;
ticket.CompanyId = lc.CompanyId;
ticket.JobTicketId = jth.Add(ticket, User.Identity.Name);
}
else
{
ticket.ModifiedBy = User.Identity.Name;
jth.Update(ticket);
}
// Save to db here
// Assign job ticket number to the object
// return jobTicket
return Json(new { success = true, message = ticket }, JsonRequestBehavior.AllowGet);
}
