public string InsertNewMember(ESocietyEL el)
{
try
{
SocietyMemberInfo newrow = new SocietyMemberInfo();
newrow.Password = Membership.GeneratePassword(8, 0);
newrow.Name = el.Name;
newrow.Address = el.Address;
newrow.Email = el.Email;
newrow.ContactNumber = el.ContactNumber;
newrow.AccountType = el.AccountType;
newrow.HouseNo = el.HouseNo;
newrow.BusinessName = el.BusinessName;
newrow.Rent = el.Rent;
db.SocietyMemberInfoes.Add(newrow);
var res = db.SaveChanges();
if (res > 0)
{
string s = GetSMID(newrow.ContactNumber);
return("SMID : " + s + " Password : "******"Member not inserted");
}
public ESocietyEL SelectByID(int smid)
{
ESocietyEL el = new ESocietyEL();
try
{
var res = db.SocietyMemberInfoes.Where(x => x.SMID == smid).SingleOrDefault();
if (res == null)
{
return(null);
}
else
{
el.SMID = res.SMID;
el.Password = res.Password;
el.Name = res.Name;
el.Address = res.Address;
el.Email = res.Email;
el.ContactNumber = res.ContactNumber;
el.AccountType = res.AccountType;
el.HouseNo = res.HouseNo;
el.BusinessName = res.BusinessName;
el.Rent = res.Rent;
}
}
catch (Exception ex)
{
throw ex;
}
return(el);
}
public bool InsertNewMember(ESocietyEL el)
{
bool result = ValidationRegistration(el);
if (result)
{
return(dal.InsertNewMember(el));
}
return(false);
}
public string UpdateInfo(int SMID, ESocietyEL el)
{
try
{
var res = db.SocietyMemberInfoes.Where(x => x.SMID == SMID).SingleOrDefault();
if (res == null)
{
return("Invalid SMID");
}
if (res.Password != el.Password && el.Password != null)
{
res.Password = el.Password;
var op = db.SaveChanges();
if (op > 0)
{
return("Password Updated");
}
}
else
{
res.Name = el.Name;
res.Address = el.Address;
res.Email = el.Email;
res.ContactNumber = el.ContactNumber;
res.AccountType = el.AccountType;
res.HouseNo = el.HouseNo;
res.BusinessName = el.BusinessName;
res.Rent = el.Rent;
var op = db.SaveChanges();
if (op > 0)
{
return("Information Updated");
}
}
}
catch (Exception ex)
{
throw ex;
}
return("Information not Updated");
}
private bool ValidationRegistration(ESocietyEL rd)
{
Regex emailpattern = new Regex(@"^\S+@\S+$");
if (emailpattern.IsMatch(rd.Email))
{
}
else
{
throw new Exception("Invalid Email Address");
}
Regex mobnopattern = new Regex(@"\d{10}");
if (mobnopattern.IsMatch((rd.ContactNumber).ToString()))
{
}
else
{
throw new Exception("Mobile No has to be 10 digits");
}
return(true);
}
public string UpdateInfo([FromUri] int SMID, ESocietyEL el)
{
return(dal.UpdateInfo(SMID, el));
}
public string Post([FromBody] ESocietyEL el)
{
return(dal.InsertNewMember(el));
}