//
// GET: /DealerMap/
public ActionResult Index()
{
BusinessLogic.Distributor.Distributor obj = new BusinessLogic.Distributor.Distributor();
System.Data.DataSet ds = obj.GetDistributorStateCount();
StringBuilder strBld = new StringBuilder();
strBld.Append("[");
int percentage = 0;
int id = 1;
string icon = Url.Content("~/icon/state.png");
foreach ( DataRow row in ds.Tables[0].Rows )
{
percentage = Convert.ToInt32( Convert.ToDecimal(row["Dealers"]) / (Convert.ToDecimal(row["total_Outlet"]) == 0 ? 1 : Convert.ToInt32(row["total_Outlet"])) * 100 );
strBld.Append( "{");
strBld.Append("'id': '").Append( id.ToString() ).Append("',");
strBld.Append("'title': '").Append(row["State"].ToString()).Append("',");
strBld.Append("'abbr': '").Append(row["Abbr"].ToString()).Append("',");
strBld.Append( "'state': '").Append( row["State"].ToString() ).Append("',");
strBld.Append("'region': '").Append(row["Region"].ToString()).Append("',");
strBld.Append("'totalDealers': '").Append(row["Dealers"].ToString()).Append("',");
strBld.Append("'totalOutlets': '").Append(row["total_Outlet"].ToString()).Append("',");
strBld.Append("'totalCities': '").Append(row["total_Outlet"].ToString()).Append("',");
strBld.Append("'totalJatiaCities': '").Append(row["Presence_cities"].ToString()).Append("',");
strBld.Append( "'latitude': '").Append( row["Latitude"].ToString() ).Append("',");
strBld.Append( "'longitude': '").Append( row["Longitude"].ToString() ).Append("',");
strBld.Append("'icon': '").Append( icon ).Append("',");
strBld.Append( "'wp': '").Append( "" ).Append("'");
strBld.Append( "},");
id++;
}
ViewData["Array"] = strBld.Remove(strBld.Length- 1,1).Append("]");
return View("Index");
}
public JsonResult Save()
{
StoreManifest stm = new StoreManifest();
if (!Validate(ref stm))
{
BusinessLogic.Distributor.Distributor sp = new BusinessLogic.Distributor.Distributor();
DataSet.DSParameter ds = new DataSet.DSParameter();
ds.Distributor.IDColumn.ReadOnly = false;
ds.Distributor.AddDistributorRow(stm.Is_Active, Convert.ToInt32(stm.Code), stm.Store, stm.City, stm.State,
stm.FullAddress, Convert.ToDecimal(stm.Latitude), Convert.ToDecimal(stm.Longitude), stm.Email1, stm.ZipCode, stm.Address, stm.Street_No,
stm.Street_Name, stm.Country, stm.Phone1, stm.Phone2, stm.Email2, stm.Website, stm.Is_Email1_Display, stm.Is_Email2_Display,
stm.Is_Phone1_Display, stm.Is_Phone2_Display, stm.Is_Website_Display);
ds.EnforceConstraints = false;
ds.Distributor[0]["ID"] = Convert.ToInt32(stm.ID);
if (stm.hidState == 3)
{
sp.New(ds);
}
else
{
sp.Update(ds);
}
UpdateCache();
}
return this.Json(stm, JsonRequestBehavior.AllowGet);
}
public ActionResult Direction(int? id, FormCollection collection)
{
collection = new FormCollection(ConvertRawUrlToQuerystring());
base.Activity((int)Activities.clickDealer, "Route", Convert.ToInt32(id));
ViewData["startLatitude"] = collection["strLat"];
ViewData["startLongitude"] = collection["strLog"];
ViewData["endLatitude"] = collection["endLat"];
ViewData["endLongitude"] = collection["endLog"];
BusinessLogic.Distributor.Distributor obj = new BusinessLogic.Distributor.Distributor();
obj._ID = Convert.ToInt32(collection["id"]);
DataSet.DSParameter.DistributorRow row = (DataSet.DSParameter.DistributorRow)obj.Get().Distributor.Select(" Distributor_ID = " + obj._ID)[0];
ViewData["Distributor"] = row.Distributor;
ViewData["Address"] = row.Address;
string dist = collection["dist"].Replace("/Route", "").ToString();
if (dist.LastIndexOf('.') >= 0)
{
dist = dist.Remove(dist.LastIndexOf('.'));
}
ViewData["Distributor_ID"] = row["Distributor_ID"];
ViewData["Phone1"] = row["Phone1"];
ViewData["Phone2"] = row["Phone2"];
ViewData["Website"] = row["Website"];
ViewData["Distance"] = dist;
ViewData["Email"] = row.Email;
ViewData["Querystring"] = Request.RawUrl.Substring(Request.RawUrl.LastIndexOf('?') + 1);
//ListPopulate(id, collection);
return View("RouteDirection");
}
bool Validation(FormCollection collection)
{
bool is_Valid = true;
string error_Message = "";
ViewData[UIDistributor.hidLatitude.ToString()] = collection[UIDistributor.hidLatitude.ToString()];
ViewData[UIDistributor.hidLongitude.ToString()] = collection[UIDistributor.hidLongitude.ToString()];
if (collection[UIDistributor.txtDistributor.ToString()].Length < 2)
{
error_Message += "* Enter valid name. <br>";
is_Valid = false;
}
string pattern = @"^[a-z][a-z|0-9|]*([_][a-z|0-9]+)*([.][a-z|" +
@"0-9]+([_][a-z|0-9]+)*)?@[a-z][a-z|0-9|]*\.([a-z]" +
@"[a-z|0-9]*(\.[a-z][a-z|0-9]*)?)$";
System.Text.RegularExpressions.Match match =
Regex.Match(collection[UIDistributor.txtEmail.ToString()].Trim(), pattern, RegexOptions.IgnoreCase);
if (!match.Success)
{
error_Message += "* Invalid email address. <br>";
is_Valid = false;
}
if (match.Success)
{
BusinessLogic.Distributor.Distributor con = new BusinessLogic.Distributor.Distributor();
int _totalCount = 0;
//con.GetPage(1, 10, ref _totalCount, null, null, null, collection[UIDistributor.txtEmail.ToString()].Trim(), null, null, null, null, null);
if (_totalCount > 0)
{
error_Message += "* User " + collection[UIDistributor.txtEmail.ToString()].Trim() + " had already been mQuoted<br>";
is_Valid = false;
}
}
if (collection[UIDistributor.txtPhone.ToString()].Length < 5)
{
error_Message += "* Enter valid day phone No. <br>";
is_Valid = false;
}
if (collection[UIDistributor.txtZipCode.ToString()].Length < 2)
{
error_Message += "* Enter valid zip code. <br>";
is_Valid = false;
}
//if (collection[UIDistributor.txtBuildingAppartment.ToString()].Trim().Length < 2)
//{
// error_Message += "Enter valid building/Apartment.<br>";
// is_Valid = false;
//}
ViewData["ErrorMessage"] = error_Message;
return is_Valid;
}
ActionResult Save(FormCollection collection)
{
if (!Validation(collection))
{
SetCollectionToView(collection);
return View("Distributor");
}
DataSet.DSParameter ds = SetViewToDS(collection);
BusinessLogic.Distributor.Distributor obj = new BusinessLogic.Distributor.Distributor();
DSParameter _ds = obj.New(ds);
//string fromEmail = "*****@*****.**";//sending email from...
//string ToEmail = _ds.Distributor[0]["Email"].ToString();
//string body = "testing testing testing";
//string subject = "mQuote process initiation Notification";
//try
//{
// SmtpClient sMail = new SmtpClient("smtp.gmail.com");//"aimexch.aiminsight.com");//exchange or smtp server goes here.
// sMail.Port = 587;
// sMail.EnableSsl = true;
// sMail.Credentials = new NetworkCredential("*****@*****.**", "has537167");// "aiminsight/eric", "aiminsight1");// ( this line most likely wont be needed if you are already an authenticated user.
// ViewData[UIDistributorReceivedMail.lblCustomer.ToString()] = _ds.Distributor[0]["Customer_Name"].ToString();
// ViewData[UIDistributorReceivedMail.lblQuote_No.ToString()] = "000" + _ds.Distributor[0]["Distributor_ID"].ToString();
// ViewData[UIDistributorReceivedMail.lblEmail.ToString()] = _ds.Distributor[0]["Email"].ToString();
// ViewData[UIDistributorReceivedMail.lblLogonLink.ToString()] = " http://wdllc.aiminsight.com/Martifer/Tracking/Logon";// Model.Utility.Get_Path() + "/Tracking/Logon";
// MailMessage mm = new MailMessage(fromEmail, ToEmail, subject, RenderViewToStringAsHTML(this, "Mail", ViewData));
// mm.IsBodyHtml = true;
// sMail.Send(mm);
//}
//catch (Exception ex)
//{
// //do something after error if there is one
//}
ViewData["GenericMessage"] = "your business detial has been saved<br/> <br/>and is puted forward for further process";
return View("GenericMessage");
}
