// GET: MyClients
public ActionResult Index()
{
logger.Info("Simplex Invoice MyClients. Index()");
if (!User.Identity.IsAuthenticated)
{
return RedirectToAction("Login", "Account");
}
ClientCompany c = null;
if (c == null)
{
c = new ClientCompany();
c.CompanyName = string.Empty;
c.ContactPerson = string.Empty;
c.AddressLine1 = string.Empty;
c.AddressLine2 = string.Empty;
c.City = string.Empty;
c.State = "NY";
c.Zip = string.Empty;
c.Email = string.Empty;
c.MobileNumber = string.Empty;
c.OfficeNumber = string.Empty;
c.FaxNumber = string.Empty;
}
lc = lch.GetCompanyRegisteredByUser(User.Identity.Name);
if(lc != null)
{
c.WeightRate = lc.WeightRate;
c.ComplimentaryWeight = lc.ComplimentaryWeight;
c.BasePickupCharge = lc.BasePickupCharge;
}
ViewData["PU_FORM"] = c;
return View();
}
public int Delete(ClientCompany c)
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
conn.Open();
int result = conn.Execute(@"
delete invoice.[MyClients]
where CompanyId = @CompanyId
", c);
return result;
}
}
public int Update(ClientCompany c)
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
conn.Open();
int result = conn.Execute(@"
update invoice.[MyClients]
set CompanyName = @CompanyName
,ContactPerson = @ContactPerson
,AddressLine1 = @AddressLine1
,AddressLine2 = @AddressLine2
,City = @City
,State = @State
,Zip = @Zip
,Email = @Email
,MobileNumber = @MobileNumber
,OfficeNumber = @OfficeNumber
,FaxNumber = @FaxNumber
,BillToName = @BillToName
,BillToAddressLine1 = @BillToAddressLine1
,BillToAddressLine2 = @BillToAddressLine2
,BillToCity = @BillToCity
,BillToState = @BillToState
,BillToZip = @BillToZip
,ComplimentaryWeight = @ComplimentaryWeight
,BasePickupCharge = @BasePickupCharge
,WeightRate = @WeightRate
,ModifiedBy = @ModifiedBy
,ModifiedAt = getdate()
where ClientCompanyId = @ClientCompanyId
", c);
return result;
}
}
public int Add(ClientCompany c)
{
using (var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
conn.Open();
var result = conn.Query<int>(@"
insert into invoice.[MyClients](CompanyId,CompanyName,ContactPerson,
AddressLine1,AddressLine2,City,State,Zip,Email,
MobileNumber,OfficeNumber,FaxNumber,ComplimentaryWeight,WeightRate,
BillToName,BillToAddressLine1,BillToAddressLine2,BillToCity,BillToState,BillToZip,
BasePickupCharge,CreatedBy,CreatedAt)
values(@CompanyId,@CompanyName,@ContactPerson,
@AddressLine1,@AddressLine2,@City,@State,@Zip,@Email,
@MobileNumber,@OfficeNumber,@FaxNumber,@ComplimentaryWeight,@WeightRate,
@BillToName,@BillToAddressLine1,@BillToAddressLine2,@BillToCity,@BillToState,@BillToZip,
@BasePickupCharge,@CreatedBy,getdate());
SELECT SCOPE_IDENTITY()
", c);
return result.FirstOrDefault();
}
}
public ActionResult Editing_Destroy([DataSourceRequest] DataSourceRequest request, ClientCompany company)
{
string destinationFilePath = System.Web.HttpContext.Current.Server.MapPath("~/Content/products");
try
{
//string fileToDelete = string.Format(@"{0}\{1}", destinationFilePath, product.OriginalImageId);
//FileInfo fi = new FileInfo(fileToDelete);
//if (fi.Exists)
//{
// try
// {
// fi.Delete();
// }
// catch { }
//}
//fileToDelete = string.Format(@"{0}\{1}", destinationFilePath, product.SmallImageId);
//fi = new FileInfo(fileToDelete);
//if (fi.Exists)
//{
// try
// {
// fi.Delete();
// }
// catch { }
//}
//fileToDelete = string.Format(@"{0}\{1}", destinationFilePath, product.MediumImageId);
//fi = new FileInfo(fileToDelete);
//if (fi.Exists)
//{
// try
// {
// fi.Delete();
// }
// catch { }
//}
//fileToDelete = string.Format(@"{0}\{1}", destinationFilePath, product.LargeImageId);
//fi = new FileInfo(fileToDelete);
//if (fi.Exists)
//{
// try
// {
// fi.Delete();
// }
// catch { }
//}
//fileToDelete = string.Format(@"{0}\{1}", destinationFilePath, product.ImageIdOne);
//fi = new FileInfo(fileToDelete);
//if (fi.Exists)
//{
// try
// {
// fi.Delete();
// }
// catch { }
//}
//fileToDelete = string.Format(@"{0}\{1}", destinationFilePath, product.ImageIdTwo);
//fi = new FileInfo(fileToDelete);
//if (fi.Exists)
//{
// try
// {
// fi.Delete();
// }
// catch { }
//}
//fileToDelete = string.Format(@"{0}\{1}", destinationFilePath, product.ImageIdThree);
//fi = new FileInfo(fileToDelete);
//if (fi.Exists)
//{
// try
// {
// fi.Delete();
// }
// catch { }
//}
//fileToDelete = string.Format(@"{0}\{1}", destinationFilePath, product.ImageIdFour);
//fi = new FileInfo(fileToDelete);
//if (fi.Exists)
//{
// try
// {
// fi.Delete();
// }
// catch { }
//}
//fileToDelete = string.Format(@"{0}\{1}", destinationFilePath, product.ImageIdFive);
//fi = new FileInfo(fileToDelete);
//if (fi.Exists)
//{
// try
// {
// fi.Delete();
// }
// catch { }
//}
}
catch (Exception ex)
{
logger.Fatal(ex);
}
//productHandler.DeleteProduct(product);
return Json(new[] { company }.ToDataSourceResult(request, ModelState));
}
public ActionResult Editing_Update([DataSourceRequest] DataSourceRequest request, ClientCompany company)
{
//productHandler.UpdateProduct(product);
return Json(new[] { company }.ToDataSourceResult(request, ModelState));
}
public ActionResult Editing_Create([DataSourceRequest] DataSourceRequest request, ClientCompany company)
{
//var addedProduct = productHandler.AddProduct(product);
//if (addedProduct != null)
//{
// ViewBag.Message = "Record saved";
// ViewBag.ErrorFound = false;
// product.ProductID = addedProduct.ProductID;
//}
//else
//{
// ViewBag.Message = "Failed to save record";
// ViewBag.ErrorFound = true;
//}
return Json(new[] { company }.ToDataSourceResult(request, ModelState));
}
public ActionResult GetClientInfo([DataSourceRequest]DataSourceRequest request, string clientCompanyString)
{
string message = "Getting company";
if (lc == null)
lc = lch.GetCompanyRegisteredByUser(User.Identity.Name);
ClientCompany c = cch.GetClientCompanyByName(clientCompanyString,lc);
if (c == null)
{
c = new ClientCompany();
c.CompanyName = clientCompanyString;
c.ContactPerson = string.Empty;
c.AddressLine1 = string.Empty;
c.AddressLine2 = string.Empty;
c.City = string.Empty;
c.State = "NY";
c.Zip = string.Empty;
c.Email = string.Empty;
c.MobileNumber = string.Empty;
c.OfficeNumber = string.Empty;
c.FaxNumber = string.Empty;
c.WeightRate = 3;
c.ComplimentaryWeight = 1000;
c.BasePickupCharge = 56;
}
return Json(new { success = true, message = c }, JsonRequestBehavior.AllowGet);
}
