public ActionResult DeleteConfirmed(int id)
{
TOwner tOwner = db.TOwners.Find(id);
db.TOwners.Remove(tOwner);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult OwnerHome(int?id)
{
TOwner owner = new TOwner();
if (Session["intUserID"] == null)
{
//ViewBag.ErrorMessage = "Authorized Users Only";
return(RedirectToAction("Login"));
}
else
{
int intOwnerID = (int)id;
//int? intOwnerID = db.uspGetOwnerID(id).FirstOrDefault();
OwnerHome ownerHome = new OwnerHome();
owner = db.TOwners.Include(s => s.TPets).SingleOrDefault(s => s.intOwnerID == id);
if (Session["intUserID"].ToString() != owner.intUserID.ToString())
{
//ViewBag.ErrorMessage = "Authorized Users Only";
return(RedirectToAction("Login"));
}
else
{
if (owner.TUser.intRoleID != 1)
{
ViewBag.ErrorMessage = "Authorized Users Only";
Logout();
}
List <PetOwnerImage> list = (from o in db.TOwners
join p in db.TPets
on o.intOwnerID equals p.intOwnerID
join i in db.TPetImages
on p.intPetID equals i.intPetID
join s in db.TStates
on o.intStateID equals s.intStateID
where o.intOwnerID == owner.intOwnerID
select new PetOwnerImage
{
intOwnerID = owner.intOwnerID,
strFirstName = o.strFirstName,
strLastName = o.strLastName,
intPetID = p.intPetID,
strPetName = p.strPetName,
intPetImageID = i.intPetImageID,
}).ToList();
ownerHome.PetImageData = list;
ownerHome.strFirstName = owner.strFirstName;
ownerHome.strLastName = owner.strLastName;
return(View(ownerHome));
}
}
}
// GET: TOwners/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TOwner tOwner = db.TOwners.Find(id);
if (tOwner == null)
{
return(HttpNotFound());
}
return(View(tOwner));
}
public ActionResult Edit([Bind(Include = "intOwnerID,strFirstName,strLastName,intGenderID,strAddress,strCity,intStateID,strZip,strPhoneNumber,strEmail,strOwner2Name,strOwner2PhoneNumber,strOwner2Email,strNotes,intUserID")] TOwner tOwner)
{
if (ModelState.IsValid)
{
db.Entry(tOwner).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.intStateID = new SelectList(db.TStates, "intStateID", "strStateCode", tOwner.intStateID);
ViewBag.intUserID = new SelectList(db.TUsers, "intUserID", "strUserName", tOwner.intUserID);
ViewBag.intGenderID = new SelectList(db.TGenders, "intGenderID", "strGender", tOwner.intGenderID);
return(View(tOwner));
}
public ActionResult Create([Bind(Include = "intOwnerID,strFirstName,strLastName,intGenderID,strAddress,strCity,intStateID,strZip,strPhoneNumber,strEmail,strOwner2Name,strOwner2PhoneNumber,strOwner2Email,strNotes")] TOwner tOwner)
{
if (ModelState.IsValid)
{
ObjectParameter strUserName = new ObjectParameter("strUserName", typeof(string));
ObjectParameter strPassword = new ObjectParameter("strPassword", typeof(string));
var data = db.uspAddUserOwner(strUserName, strPassword, tOwner.strFirstName, tOwner.strLastName, tOwner.intGenderID, tOwner.strAddress, tOwner.strCity, tOwner.intStateID, tOwner.strZip, tOwner.strPhoneNumber, tOwner.strEmail, tOwner.strOwner2Name, tOwner.strOwner2PhoneNumber, tOwner.strOwner2Email, tOwner.strNotes);
string UserName = Convert.ToString(strUserName.Value);
string Password = Convert.ToString(strPassword.Value);
string from = "*****@*****.**";
string to = tOwner.strEmail;
MailMessage mm = new MailMessage(from, to);
mm.Subject = "Capstone Pets - Login Credentials";
mm.Body = "[ Username: "******" ] [ Password: "******" ]";
mm.IsBodyHtml = false;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.EnableSsl = true;
NetworkCredential nc = new NetworkCredential("*****@*****.**", "capstonepets21");
smtp.UseDefaultCredentials = true;
smtp.Credentials = nc;
smtp.Send(mm);
return(RedirectToAction("Index"));
}
ViewBag.intStateID = new SelectList(db.TStates, "intStateID", "strStateCode", tOwner.intStateID);
return(View(tOwner));
}
// GET: TOwners/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
TOwner tOwner = db.TOwners.Find(id);
if (tOwner == null)
{
return(HttpNotFound());
}
ViewBag.intStateID = new SelectList(db.TStates, "intStateID", "strStateCode", tOwner.intStateID);
ViewBag.intUserID = new SelectList(db.TUsers, "intUserID", "strUserName", tOwner.intUserID);
ViewBag.intGenderID = new SelectList(db.TGenders, "intGenderID", "strGender", tOwner.intGenderID);
return(View(tOwner));
}
public override bool Execute(TOwner owner) => Action(owner, Input);
public abstract bool Execute(TOwner owner);
/// <summary>
/// Constructor.
/// </summary>
/// <param name="owner">Not null.</param>
/// <param name="ownerComparer">Not null.</param>
/// <exception cref="ArgumentNullException"></exception>
/// <param name="holdStrongReferenceNow"></param>
public Search(TOwner owner, IEqualityComparer <TOwner> ownerComparer)
: base(owner, true, ownerComparer)
{
}
//protected void lbtnARC_Click(object sender, EventArgs e)
//{
// if (!string.IsNullOrEmpty(txtARCNum.Text))
// {
// divARC.Visible = true;
// IList owner = _MemberInformationService.GetOwnerByARC(txtARCNum.Text);
// if (owner.Count > 0)
// {
// TOwner item = (TOwner)owner[0];
// lblArcCode.Text = item.OwnerCode;
// lblComName.Visible = true;
// lblComName.Text = item.CompanyName;
// txtComName.Visible = false;
// lblOwnFistName.Visible = true;
// lblOwnFistName.Text = item.FistName;
// txtOwnFistName.Visible = false;
// lblOwnMiddleName.Visible = true;
// lblOwnMiddleName.Text = item.MiddleName;
// txtOwnMiddleName.Visible = false;
// lblOwnLastName.Visible = true;
// lblOwnLastName.Text = item.LastName;
// txtOwnLastName.Visible = false;
// }
// else
// {
// lblArcCode.Text = string.Empty;
// txtComName.Visible = true;
// lblComName.Visible = false;
// txtComName.Text = string.Empty;
// txtComName.Visible = true;
// lblComName.Visible = false;
// txtOwnFistName.Text = string.Empty;
// txtOwnFistName.Visible = true;
// lblOwnFistName.Visible = false;
// txtOwnMiddleName.Text = string.Empty;
// txtOwnMiddleName.Visible = true;
// lblOwnMiddleName.Visible = false;
// txtOwnLastName.Text = string.Empty;
// txtOwnLastName.Visible = true;
// lblOwnLastName.Visible = false;
// }
// }
//}
protected void Button1_Click(object sender, EventArgs e)
{
System.Data.SqlClient.SqlConnection con = new System.Data.SqlClient.SqlConnection(TextBox1.Text);
System.Data.SqlClient.SqlCommand select = new System.Data.SqlClient.SqlCommand("Select * FROM Subagent", con);
System.Data.SqlClient.SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(select);
DataTable dt = new DataTable("Subagent");
da.Fill(dt);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
IList owners = _MemberInformationService.GetOwnerByARC(dt.Rows[i]["ARCNumber"].ToString());
Terms.Member.Business.MemberInformation meta = new Terms.Member.Business.MemberInformation();
meta.FirstName = dt.Rows[i]["ContectPersonFirstName"].ToString();
meta.MiddleName = dt.Rows[i]["ContectPersonMiddleName"].ToString();
meta.LastName = dt.Rows[i]["ContectPersonLastName"].ToString();
meta.Gender = Convert.ToInt32(0);
meta.EmailAddress = dt.Rows[i]["Email"].ToString();
meta.Password = MemberUtility.Lock(dt.Rows[i]["Password"].ToString());
meta.PhoneDay = dt.Rows[i]["BusinessPhone"].ToString();
meta.City = dt.Rows[i]["City"].ToString();
meta.StreetAddress = dt.Rows[i]["Address"].ToString();
meta.Nation = "US";
meta.Province = dt.Rows[i]["State"].ToString();
meta.ZipCode = dt.Rows[i]["Zip"].ToString();
meta.Remark = dt.Rows[i]["History"].ToString();
meta.Source = "MVB2B";
meta.MemberType = 1;
if (dt.Rows[i]["Status"].ToString() == "1")
{
meta.Status = "1";
}
else
{
meta.Status = "2";
}
TOwner owner = new TOwner();
if (owners == null || owners.Count == 0)
{
owner.ArcNum = dt.Rows[i]["ARCNumber"].ToString();
owner.CompanyName = dt.Rows[i]["CompanyName"].ToString();
owner.FistName = dt.Rows[i]["OwnerFirstName"].ToString();
owner.MiddleName = dt.Rows[i]["OwnerMiddleName"].ToString();
owner.LastName = dt.Rows[i]["OwnerLastName"].ToString();
}
else
{
owner.OwnerCode = ((TOwner)owners[0]).OwnerCode;
}
//IList owner = _MemberInformationService.GetOwnerByARC(txtARCNum.Text);
_MemberInformationService.SaveNewMemberInformation(meta, owner);
}
}
}
protected void btnCreat_Click(object sender, EventArgs e)
{
string strCPEmail = txtCPEmail.Text;
string strPwd = txtPwd.Text;
string strPwdAgain = txtPwdAgain.Text;
string strCPFirstName = txtCPFirstName.Text;
string strCPMiddleName = txtCPMiddleName.Text;
string strCPLastName = txtCPLastName.Text;
string strCPTel = txtCPTel.Text;
string strCPFax = txtCPFax.Text;
string strCPAddress = txtCPAddress.Text;
string strCPCity = txtCPCity.Text;
string strCPCountry = dllCPCountry.SelectedValue;
string strCPState = dllCPState.SelectedValue;
string strCPZip = txtCPZip.Text;
string strARCNum = "";//txtARCNum.Text;
string strComName = txtComName.Text;
string strOwnFistName = "";//txtOwnFistName.Text;
string strOwnMiddleName = "";//txtOwnMiddleName.Text;
string strOwnLastName = "";//txtOwnLastName.Text;
if (string.IsNullOrEmpty(strCPEmail.Trim()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert('Email is null. Choose another');</script>");
return;
}
if (!System.Text.RegularExpressions.Regex.IsMatch(strCPEmail, @"\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*"))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert('Email Format error. Choose another');</script>");
return;
}
int iCount = _MemberInformationService.GetEmail(strCPEmail, 1);
if (iCount > 0)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert('Email Address entered is already in use. Choose another');</script>");
return;
}
if (string.IsNullOrEmpty(strPwd.Trim()) && string.IsNullOrEmpty(strPwdAgain.Trim()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert(' Password and Password again must enter ');</script>");
return;
}
if (!strPwd.Trim().Equals(strPwdAgain.Trim()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert('You enterd the diffrent password');</script>");
return;
}
if (string.IsNullOrEmpty(strCPFirstName.Trim()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert('First Name must enter');</script>");
return;
}
if (string.IsNullOrEmpty(strCPLastName.Trim()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert('Last Name must enter');</script>");
return;
}
if (string.IsNullOrEmpty(strCPTel.Trim()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert('Telphone must enter');</script>");
return;
}
if (string.IsNullOrEmpty(strCPAddress.Trim()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert('Address must enter');</script>");
return;
}
if (string.IsNullOrEmpty(strCPCity.Trim()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert('City must enter');</script>");
return;
}
if (string.IsNullOrEmpty(strCPCountry.Trim()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert('Email Address entered is already in use. Choose another');</script>");
return;
}
if (string.IsNullOrEmpty(strCPState.Trim()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert('Email Address entered is already in use. Choose another');</script>");
return;
}
if (string.IsNullOrEmpty(strCPZip.Trim()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert('ZipCode must enter');</script>");
return;
}
if (string.IsNullOrEmpty(strComName.Trim()))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "Warting", "<script language=javascript>alert('Company Name must enter');</script>");
return;
}
Terms.Member.Business.MemberInformation meta = new Terms.Member.Business.MemberInformation();
meta.FirstName = strCPFirstName;
meta.MiddleName = strCPMiddleName;
meta.LastName = strCPLastName;
meta.Gender = Convert.ToInt32(0);
meta.EmailAddress = strCPEmail;
meta.Password = MemberUtility.Lock(strPwd);
meta.Password1 = strPwd;
meta.PhoneDay = strCPTel;
meta.City = strCPCity;
meta.StreetAddress = strCPAddress;
meta.Nation = strCPCountry;
meta.Province = strCPState;
meta.ZipCode = strCPZip;
meta.Remark = strCPFax;
meta.Source = "MVB2B";
meta.MemberType = 1;
meta.Status = "0";
List<Terms.Member.Utility.HandlerReceiver> Citys = Terms.Member.Utility.MemberUtility.GetHandlerReciever();
List<string> CityCodes = new List<string>();
string HandlerName = string.Empty;
for (int i = 0; i < Citys.Count; i++)
{
CityCodes.Clear();
if (Citys[i].CityCode.Trim().Length > 0)
{
CityCodes.AddRange(Citys[i].CityCode.Split(new char[] { ',' }));
}
for (int j = 0; j < CityCodes.Count; j++)
{
if (CityCodes[j].Trim().ToUpper() == meta.City.Trim().ToUpper())
{
HandlerName = Citys[i].Name;
}
}
}
//if (string.IsNullOrEmpty(HandlerName))
//{
// for (int i = 0; i < Citys.Count; i++)
// {
// CityCodes.Clear();
// if (Citys[i].CityCode.Trim().Length > 0)
// {
// CityCodes.AddRange(Citys[i].CityCode.Split(new char[] { ',' }));
// }
// List<City> CityList = new List<City>();
// for (int j = 0; j < CityCodes.Count; j++)
// {
// City city = _CommonService.FindCityByCityCode(CityCodes[j].Trim());
// if (city != null && city.Name.Trim().ToUpper() == meta.City.Trim().ToUpper())
// {
// HandlerName = Citys[i].Name;
// break;
// }
// }
// if (!string.IsNullOrEmpty(HandlerName))
// {
// break;
// }
// }
//}
if (string.IsNullOrEmpty(HandlerName))
{
HandlerName = "DEFAULT";
}
meta.Handler = HandlerName;
TOwner owner = new TOwner();
owner.ArcNum = strARCNum;
owner.CompanyName = strComName;
owner.FistName = strOwnFistName;
owner.MiddleName = strOwnMiddleName;
owner.LastName = strOwnLastName;
owner.GTTAccountCode = String.Empty;
string strMemberCode = _MemberInformationService.SaveNewMemberInformation(meta, owner);
MailMessage mailMessage = new MailMessage();
mailMessage.From = new MailAddress(@"*****@*****.**");
mailMessage.To.Add(new MailAddress(strCPEmail));
mailMessage.IsBodyHtml = true;
mailMessage.Subject = "Thank You for Registering!";
mailMessage.Body = "Thank for registering our Majestic Vacations Travel Agent Website. " +
"We will review your application within next 2 business day " +
"and let you know if your application is approved " +
"or if any additonal infomation are required.";
Terms.Member.Utility.MemberUtility.SendEmail(mailMessage, "B2BMembership");
OperaterAdvice.DoAdvice(Terms.Configuration.Utility.ConfigurationConst.OperateType.SUB_RegisterMember, this);
this.Response.Redirect("AgentJoinSucceedForm.aspx");
}
