public void LoadMCSale()
{
int MCID = Convert.ToInt32(Request.QueryString["MCID"]);
MCSaleEntity mcSale = mcSalesHelper.GetMCSale(MCID);
Session["MCSaleNo"] = mcSale.MCSaleNo;
txtAddressOnCard.Text = mcSale.AddressOnCard;
lblSalesPersonName.Text = userHelper.GetComplianceUserByID(Convert.ToInt32(mcSale.SalesPersonID)).Name;
txtDOT.Text = mcSale.DotNo;
txtMC.Text = mcSale.MCNo;
txtCardNo.Text = mcSale.CardNo;
hidCardNo.Value = mcSale.CardNo;
txtNameOnCard.Text = mcSale.NameOnCard;
txtPhysicalAddress.Text = mcSale.PhysicalAddress;
txtRecieptEmail.Text = mcSale.Email;
lblMCSaleNo.Text = mcSale.MCSaleNo;
txtExpirationDate.Text = mcSale.ExpirationDate;
txtCVC.Text = mcSale.CVC;
txtPhoneNo.Text = mcSale.PhoneNo;
ulcardtype.Attributes["class"] = mcSale.CardType;
txtDBA.Text = mcSale.DBA;
txtLegalName.Text = mcSale.LegalName;
txtDOTPin.Text = mcSale.DotPin;
foreach (MCServiceSaleEntity item in mcSale.serviceSaleData)
{
DocumentEL docEL = new DocumentEL();
docEL.Description = item.ServicePrice;
docEL.DocumentID = documentDal.GetDocumentTypeByName(item.ServiceName).DocumentTypeID;
docEL.DocumentTypeName = item.ServiceName;
serviceListData.Add(docEL);
}
Session["services"] = serviceListData;
}
public bool EditMCSales(MCSaleEntity mcSale)
{
bool isEdited = false;
using (uow = new UnitOfWork.UnitOfWork())
{
try
{
MCSale mcSaledb = new MCSale();
mcSaledb = uow.MCSaleRepository.Get().Where(mcdata => mcdata.MCID == mcSale.MCID).FirstOrDefault();
mcSaledb.AddressOnCard = mcSale.AddressOnCard;
mcSaledb.DotNo = mcSale.DotNo;
mcSaledb.Email = mcSale.Email;
mcSaledb.MCID = mcSale.MCID;
mcSaledb.MCNo = mcSale.MCNo;
mcSaledb.CardNo = mcSale.CardNo;
mcSaledb.PhoneNo = mcSale.PhoneNo;
mcSaledb.NameOnCard = mcSale.NameOnCard;
mcSaledb.PhysicalAddress = mcSale.PhysicalAddress;
mcSaledb.CardType = mcSale.CardType;
mcSaledb.CVC = mcSale.CVC;
mcSaledb.MCSaleNo = mcSale.MCSaleNo;
mcSaledb.ExpirationDate = mcSale.ExpirationDate;
mcSaledb.LegalName = mcSale.LegalName;
mcSaledb.DBA = mcSale.DBA;
mcSaledb.DotPin = mcSale.DotPin;
uow.MCSaleRepository.Update(mcSaledb);
uow.Save();
List <MCServiceSale> mcTemp = uow.MCServiceSaleRepository.Get().Where(x => x.MCSaleID == mcSale.MCID).ToList();
foreach (MCServiceSale item in mcTemp)
{
uow.MCServiceSaleRepository.Delete(item);
uow.Save();
}
foreach (MCServiceSaleEntity item in mcSale.serviceSaleData)
{
MCServiceSale mcServiceSaledb = new MCServiceSale();
mcServiceSaledb.MCSaleID = mcSaledb.MCID;
mcServiceSaledb.ServiceID = item.ServiceID;
uow.MCServiceSaleRepository.Insert(mcServiceSaledb);
uow.Save();
}
isEdited = true;
}
catch
{
isEdited = false;
}
}
return(isEdited);
}
public static string GetUSDOTDetails(string usdotno)
{
MCSaleHelper mcSaleHelper = new MCSaleHelper();
MCSaleEntity mcSale = mcSaleHelper.GetMCSaleUSDotNo(usdotno);
if (mcSale == null)
{
DailyLeadsHelper leadHelper = new DailyLeadsHelper();
DailyLeadEntity LeadsData = leadHelper.GetLeadRecordsByDOTNo(usdotno);
var json = new JavaScriptSerializer().Serialize(LeadsData);
return(json);
}
var jsonSale = new JavaScriptSerializer().Serialize(mcSale);
return(jsonSale);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
serviceListData = (List <DocumentEL>)Session["services"];
List <MCServiceSaleEntity> saleServiceEntity = new List <MCServiceSaleEntity>();
if (serviceListData != null)
{
foreach (DocumentEL item in serviceListData)
{
MCServiceSaleEntity mcsale = new MCServiceSaleEntity();
mcsale.ServiceID = item.DocumentID;
saleServiceEntity.Add(mcsale);
}
}
MCSaleEntity mcData = new MCSaleEntity();
mcData.AddressOnCard = txtAddressOnCard.Text;
mcData.DotNo = txtDOT.Text;
mcData.Email = txtRecieptEmail.Text;
mcData.MCNo = txtMC.Text;
mcData.CardNo = hidCardNo.Value;
mcData.NameOnCard = txtNameOnCard.Text;
mcData.PhysicalAddress = txtPhysicalAddress.Text;
mcData.serviceSaleData = saleServiceEntity;
mcData.saleType = SaleType.Submitted;
mcData.SalesPersonID = Convert.ToInt32(Request.Cookies["UserID"].Value);
mcData.MCID = Convert.ToInt32(Request.QueryString["MCID"]);
mcData.ExpirationDate = txtExpirationDate.Text;
mcData.CVC = txtCVC.Text;
mcData.PhoneNo = txtPhoneNo.Text;
mcData.CardType = ulcardtype.Attributes["class"];
mcData.MCSaleNo = Session["MCSaleNo"].ToString();
mcData.LegalName = txtLegalName.Text;
mcData.DBA = txtDBA.Text;
mcData.DotPin = txtDOTPin.Text;
mcSalesHelper.AddMCSales(mcData);
EmailHelper emailHelper = new EmailHelper();
emailHelper.SendPlainEmail("New MC Sale Order", "A new sales order is been closed by " + Request.Cookies["Name"].Value + " (" + Request.Cookies["Email"].Value + "). Please login into admin panel to view orders.", "");
Response.Write("<script>alert('Details Submitted Successfully.You cant edit them back.');</script>");
Response.Redirect("ListSubmittedMCProfiles.aspx");
}
catch
{
}
}
protected void btnSaveDriver_Click(object sender, EventArgs e)
{
try
{
serviceListData = (List <DocumentEL>)Session["services"];
List <MCServiceSaleEntity> saleServiceEntity = new List <MCServiceSaleEntity>();
if (serviceListData != null)
{
foreach (DocumentEL item in serviceListData)
{
MCServiceSaleEntity mcsale = new MCServiceSaleEntity();
mcsale.ServiceID = item.DocumentID;
saleServiceEntity.Add(mcsale);
}
}
MCSaleEntity mcData = new MCSaleEntity();
mcData.AddressOnCard = txtAddressOnCard.Text;
mcData.DotNo = txtDOT.Text;
mcData.Email = txtRecieptEmail.Text;
mcData.MCNo = txtMC.Text;
mcData.PhoneNo = txtPhoneNo.Text;
mcData.NameOnCard = txtNameOnCard.Text;
mcData.PhysicalAddress = txtPhysicalAddress.Text;
mcData.serviceSaleData = saleServiceEntity;
mcData.saleType = SaleType.Saved;
mcData.CardNo = hidCardNo.Value;
mcData.SalesPersonID = Convert.ToInt32(Request.Cookies["UserID"].Value);
mcData.ExpirationDate = txtExpirationDate.Text;
mcData.CVC = txtCVC.Text;
mcData.MCSaleNo = hidSaleNo.Value;
mcData.CardType = ulcardtype.Attributes["class"];
mcData.PhoneNo = txtPhoneNo.Text;
mcData.LegalName = txtLegalName.Text;
mcData.DBA = txtDBA.Text;
mcData.DotPin = txtDOTPin.Text;
mcSalesHelper.AddMCSales(mcData);
Session["services"] = null;
Response.Redirect("ListSavedMCProfiles.aspx");
}
catch
{
}
}
protected void btnEditProfile_Click(object sender, EventArgs e)
{
int MCID = Convert.ToInt32(Request.QueryString["MCID"]);
MCSaleEntity mcData = new MCSaleEntity();
mcData.AddressOnCard = txtAddressOnCard.Text;
mcData.CardNo = hidCardNo.Value;
mcData.DotNo = txtDOT.Text;
mcData.Email = txtRecieptEmail.Text;
mcData.MCNo = txtMC.Text;
mcData.NameOnCard = txtNameOnCard.Text;
mcData.PhysicalAddress = txtPhysicalAddress.Text;
mcData.MCID = MCID;
mcData.ExpirationDate = txtExpirationDate.Text;
mcData.CVC = txtCVC.Text;
mcData.PhoneNo = txtPhoneNo.Text;
mcData.CardType = ulcardtype.Attributes["class"];
mcData.MCSaleNo = Session["MCSaleNo"].ToString();
mcData.LegalName = txtLegalName.Text;
mcData.DBA = txtDBA.Text;
mcData.DotPin = txtDOTPin.Text;
if (Session["services"] != null)
{
serviceListData = (List <DocumentEL>)Session["services"];
List <MCServiceSaleEntity> saleListEL = new List <MCServiceSaleEntity>();
if (serviceListData != null)
{
foreach (DocumentEL item in serviceListData)
{
MCServiceSaleEntity saleEL = new MCServiceSaleEntity();
saleEL.MCSaleID = Convert.ToInt32(Request.QueryString["MCID"]);
saleEL.ServiceID = documentDal.GetDocumentTypeByName(item.DocumentTypeName).DocumentTypeID;
saleListEL.Add(saleEL);
}
mcData.serviceSaleData = saleListEL;
}
}
mcSalesHelper.EditMCSales(mcData);
Response.Redirect("ListMCSaleAdmin.aspx");
}
public MCSaleEntity GetMCSaleUSDotNo(string USDotNo)
{
MCSaleEntity MCSale = new MCSaleEntity();
using (uow = new UnitOfWork.UnitOfWork())
{
try
{
MCSale = uow.MCSaleRepository.Get().Select(sale => new MCSaleEntity
{
AddressOnCard = sale.AddressOnCard,
DotNo = sale.DotNo,
Email = sale.Email,
MCID = sale.MCID,
MCNo = sale.MCNo,
CardNo = sale.CardNo,
PhoneNo = sale.PhoneNo,
NameOnCard = sale.NameOnCard,
PhysicalAddress = sale.PhysicalAddress,
ExpirationDate = sale.ExpirationDate,
CardType = sale.CardType,
CVC = sale.CVC,
MCSaleNo = sale.MCSaleNo,
DBA = sale.DBA,
LegalName = sale.LegalName,
SalesPersonID = sale.SalesPersonID,
DotPin = sale.DotPin,
serviceSaleData = uow.MCServiceSaleRepository.Get().Join(uow.DocumentMasterRepository.Get(), msd => msd.ServiceID, dms => dms.DocumentID, (msd, dms) => new { msd, dms })
.Select(p => new MCServiceSaleEntity {
MCSaleID = p.msd.MCSaleID, MCServiceID = p.msd.MCServiceID, ServiceID = p.msd.ServiceID, ServiceName = p.dms.DocumentName, ServicePrice = p.dms.Description
})
.Where(x => x.MCSaleID == sale.MCID).ToList()
}).Where(p => p.DotNo == USDotNo).FirstOrDefault();
}
catch
{
}
}
return(MCSale);
}
public void LoadMCSale()
{
int MCID = Convert.ToInt32(Request.QueryString["MCID"]);
MCSaleEntity mcSale = mcSalesHelper.GetMCSale(MCID);
txtAddressOnCard.Text = mcSale.AddressOnCard;
txtDOT.Text = mcSale.DotNo;
txtMC.Text = mcSale.MCNo;
txtNameOnCard.Text = mcSale.NameOnCard;
txtPhysicalAddress.Text = mcSale.PhysicalAddress;
txtRecieptEmail.Text = mcSale.Email;
txtCardNo.Text = mcSale.CardNo;
lblMCSaleNo.Text = mcSale.MCSaleNo;
txtDBA.Text = mcSale.DBA;
txtLegalName.Text = mcSale.LegalName;
txtDOTPin.Text = mcSale.DotPin;
foreach (MCServiceSaleEntity item in mcSale.serviceSaleData)
{
DocumentEL docEL = new DocumentEL();
docEL.Description = item.ServicePrice;
docEL.DocumentID = documentDal.GetDocumentTypeByName(item.ServiceName).DocumentTypeID;
docEL.DocumentTypeName = item.ServiceName;
serviceListData.Add(docEL);
}
lstServicesPurchased.DataSource = serviceListData;
lstServicesPurchased.DataBind();
Label lblTotal = lstServicesPurchased.FindControl("lblSubTotal") as Label;
try
{
lblTotal.Text = "$" + serviceListData.Sum(p => Convert.ToDouble(p.Description.Replace("$", ""))).ToString();
}
catch
{
}
}
public bool AddMCSales(MCSaleEntity mcSale)
{
bool isAdded = false;
using (uow = new UnitOfWork.UnitOfWork())
{
try
{
if (mcSale.saleType == SaleType.Submitted)
{
MCSale mcSaledb = new MCSale();
mcSaledb.AddressOnCard = mcSale.AddressOnCard;
mcSaledb.DotNo = mcSale.DotNo;
mcSaledb.Email = mcSale.Email;
mcSaledb.MCID = mcSale.MCID;
mcSaledb.MCNo = mcSale.MCNo;
mcSaledb.NameOnCard = mcSale.NameOnCard;
mcSaledb.CardNo = mcSale.CardNo;
mcSaledb.PhoneNo = mcSale.PhoneNo;
mcSaledb.PhysicalAddress = mcSale.PhysicalAddress;
mcSaledb.SoldAt = DateTimeJavaScript.GetCurrentTime().ToString();
mcSaledb.SalesPersonID = mcSale.SalesPersonID;
mcSaledb.CardType = mcSale.CardType;
mcSaledb.CVC = mcSale.CVC;
mcSaledb.MCSaleNo = mcSale.MCSaleNo;
mcSaledb.ExpirationDate = mcSale.ExpirationDate;
mcSaledb.LegalName = mcSale.LegalName;
mcSaledb.DBA = mcSale.DBA;
mcSaledb.DotPin = mcSale.DotPin;
uow.MCSaleRepository.Insert(mcSaledb);
uow.Save();
foreach (MCServiceSaleEntity item in mcSale.serviceSaleData)
{
MCServiceSale mcServiceSaledb = new MCServiceSale();
mcServiceSaledb.MCSaleID = mcSaledb.MCID;
mcServiceSaledb.ServiceID = item.ServiceID;
uow.MCServiceSaleRepository.Insert(mcServiceSaledb);
uow.Save();
}
if (mcSale.MCID == 0)
{
mcSale.MCID = mcSaledb.MCID;
}
DeleteTempSale(mcSale.MCID);
}
else
if (mcSale.saleType == SaleType.Saved)
{
MCSaleTemp mcSaleTempdb = new MCSaleTemp();
mcSaleTempdb.AddressOnCard = mcSale.AddressOnCard;
mcSaleTempdb.DotNo = mcSale.DotNo;
mcSaleTempdb.Email = mcSale.Email;
mcSaleTempdb.MCID = mcSale.MCID;
mcSaleTempdb.MCNo = mcSale.MCNo;
mcSaleTempdb.PhoneNo = mcSale.PhoneNo;
mcSaleTempdb.CardNo = mcSale.CardNo;
mcSaleTempdb.NameOnCard = mcSale.NameOnCard;
mcSaleTempdb.PhysicalAddress = mcSale.PhysicalAddress;
mcSaleTempdb.SalesPersonID = mcSale.SalesPersonID;
mcSaleTempdb.CardType = mcSale.CardType;
mcSaleTempdb.CVC = mcSale.CVC;
mcSaleTempdb.MCSaleNo = mcSale.MCSaleNo;
mcSaleTempdb.ExpirationDate = mcSale.ExpirationDate;
mcSaleTempdb.LegalName = mcSale.LegalName;
mcSaleTempdb.DBA = mcSale.DBA;
mcSaleTempdb.DotPin = mcSale.DotPin;
uow.MCSaleTempRepository.Insert(mcSaleTempdb);
uow.Save();
foreach (MCServiceSaleEntity item in mcSale.serviceSaleData)
{
MCServiceSaleTemp mcServiceSaledb = new MCServiceSaleTemp();
mcServiceSaledb.MCSaleID = mcSaleTempdb.MCID;
mcServiceSaledb.ServiceID = item.ServiceID;
uow.MCServiceSaleTempRepository.Insert(mcServiceSaledb);
uow.Save();
}
}
isAdded = true;
}
catch
{
isAdded = false;
}
}
return(isAdded);
}
