public object AddStaffMember(string Name, string MemberType, string DOB, string Contact1, string Contact2, string Image, string Document, string Address, string DOJ, string DOL, int CreatedBy)
{
var DC = new DataClassesDataContext();
tblStaffMember StaffObj = new tblStaffMember();
tblLogin returningObj = new tblLogin();
int SGFlag = 0;
StaffObj.MemberName = Name;
StaffObj.MemberType = MemberType;
StaffObj.DOB = Convert.ToDateTime(DOB);
StaffObj.IDProofDoc = Document;
StaffObj.ContactNo1 = Contact1;
StaffObj.ContactNo2 = Contact2;
StaffObj.Image = Image;
StaffObj.Address = Address;
StaffObj.DOJ = Convert.ToDateTime(DOJ);
StaffObj.DOL = Convert.ToDateTime(DOL);
StaffObj.CreatedBy = CreatedBy;
DC.tblStaffMembers.InsertOnSubmit(StaffObj);
if (MemberType == "Security Guard")
{
int MemberID = (from ob in DC.tblStaffMembers
select ob).OrderByDescending(ob => ob.MemberID).Single().MemberID;
tblLogin LoginObj = new tblLogin();
string loginName = (Name.Replace(' ', Convert.ToChar("")).Length >= 4) ? Name.Replace(' ', Convert.ToChar("")).Substring(0, 4) + MemberID : Name.Replace(' ', Convert.ToChar("")) + MemberID;
LoginObj.LoginName = loginName;
LoginObj.PhoneNo = Contact1;
LoginObj.Email = null;
LoginObj.Password = RandomPassword();
LoginObj.VerificationCode = null;
LoginObj.FlatNo = "-1";
LoginObj.MemberType = "Security Guard";
LoginObj.IsBlocked = false;
DC.tblLogins.InsertOnSubmit(LoginObj);
SGFlag = 1;
returningObj.PhoneNo = Contact1;
returningObj.Password = LoginObj.Password;
}
DC.SubmitChanges();
if (SGFlag == 1)
{
return(JsonConvert.SerializeObject(returningObj));
}
else
{
return(true);
}
}
public object EditStaffMember(int MemberID, string Name, string MemberType, string DOB, string Contact1, string Contact2, string Image, string Document, string Address, string DOJ, string DOL, int CreatedBy, bool IsActive)
{
var DC = new DataClassesDataContext();
tblStaffMember StaffObj = (from ob in DC.tblStaffMembers
where ob.MemberID == MemberID
select ob).Single();
StaffObj.MemberName = Name;
StaffObj.MemberType = MemberType;
StaffObj.DOB = Convert.ToDateTime(DOB);
StaffObj.ContactNo1 = Contact1;
StaffObj.ContactNo2 = Contact2;
StaffObj.Image = Image;
StaffObj.IDProofDoc = Document;
StaffObj.Address = Address;
StaffObj.DOJ = Convert.ToDateTime(DOJ);
if (DOL != null)
{
StaffObj.DOL = Convert.ToDateTime(DOL);
}
StaffObj.CreatedBy = CreatedBy;
StaffObj.IsActive = IsActive;
if (MemberType == "Security Guard")
{
tblLogin LoginObj = (from ob in DC.tblLogins
where ob.MemberID == MemberID
select ob).Single();
LoginObj.PhoneNo = Contact1;
LoginObj.IsBlocked = !IsActive;
//DC.tblLogins.InsertOnSubmit(LoginObj);
}
DC.SubmitChanges();
return(true);
}
