public string AddTelephoneUser(TelephoneUserInfo aTelephoneUserInfo)
{
if (!IsBANumberUnique(aTelephoneUserInfo))
{
return "Error! BANumber Already Exist In Database";
}
InsertDataInfoDatabase(aTelephoneUserInfo);
return "Telephone User Successfully Added";
}
public ActionResult AddNewTelephoneUser(TelephoneUserInfo aTelephoneUserInfo)
{
if (aTelephoneUserInfo.RankID == null)
{
ViewData["Message"] = "Error! Please Set All Fields";
ViewData["TelephoneUserInfo"] = aTelephoneUserInfo;
return View("Index");
}
if (aTelephoneUserInfo.BANumber.Trim().Length == 0
|| aTelephoneUserInfo.Appointment.Trim().Length == 0
|| aTelephoneUserInfo.EmailAddress.Trim().Length == 0
|| aTelephoneUserInfo.FullName.Trim().Length == 0
|| aTelephoneUserInfo.JoiningDate.ToString("yyyy-MM-dd") == "0001-01-01"
|| aTelephoneUserInfo.MaritalStatus.Trim().Length == 0
|| aTelephoneUserInfo.OfficeAddress.Trim().Length == 0
|| aTelephoneUserInfo.PermanentAddress.Trim().Length == 0
|| aTelephoneUserInfo.PlateName.Trim().Length == 0
|| aTelephoneUserInfo.PresentAddress.Trim().Length == 0
|| aTelephoneUserInfo.RankID.Trim().Length == 0
|| aTelephoneUserInfo.ServiceStatus.Trim().Length == 0
|| aTelephoneUserInfo.Sex.Trim().Length == 0
|| aTelephoneUserInfo.Unit.Trim().Length == 0)
{
ViewData["Message"] = "Error! Please Set All Fields";
ViewData["TelephoneUserInfo"] = aTelephoneUserInfo;
return View("Index");
}
if (aTelephoneUserInfo.ServiceStatus.Trim().ToLower() == "LPR"
&& aTelephoneUserInfo.LPRDate.ToString("yyyy-MM-dd") == "0001-01-01")
{
ViewData["Message"] = "Error! Please Set LPR Date Fields";
ViewData["TelephoneUserInfo"] = aTelephoneUserInfo;
return View("Index");
}
TelephoneUser aUser = new TelephoneUser();
string message = aUser.AddTelephoneUser(aTelephoneUserInfo);
ViewData["Message"] = message;
ViewData["TelephoneUserInfo"] = aTelephoneUserInfo;
return View("Index");
}
public TelephoneUserInfo GetTelephoneUserInfo(string baNumber)
{
TelephoneUserInfo aInfo = new TelephoneUserInfo();
string query =
"select * from phoneuserpersonalinfo " +
"left join menusrank on menusrank.id = phoneuserpersonalinfo.RankId " +
"where phoneuserpersonalinfo.BANumber='"+baNumber+"';";
DataSet aSet = aGateway.Select(query);
foreach (DataRow dataRow in aSet.Tables[0].Rows)
{
aInfo.Id = Convert.ToInt32(dataRow["ID"].ToString().Trim());
aInfo.BANumber = dataRow["BANumber"].ToString().Trim();
aInfo.FullName = dataRow["FullName"].ToString().Trim();
aInfo.RankID = dataRow["Value"].ToString().Trim();
aInfo.OfficeAddress = dataRow["OfficeAddress"].ToString().Trim();
aInfo.PresentAddress = dataRow["PresentAddress"].ToString().Trim();
}
return aInfo;
}
private bool IsBANumberUnique(TelephoneUserInfo aTelephoneUserInfo)
{
string query = "select * from phoneuserpersonalinfo where BANumber='" + aTelephoneUserInfo.BANumber + "';";
if (aGateway.Select(query).Tables[0].Rows.Count == 0)
{
return true;
}
return false;
}
private void InsertDataInfoDatabase(TelephoneUserInfo aTelephoneUserInfo)
{
string nonQuery = "INSERT INTO `phoneuserpersonalinfo` " +
"(`BANumber`, `FullName`, `Appointment`, `PlateName`, `ServiceStatus`, " +
"`RankId`, `Sex`, `Unit`, `JoiningDate`, `LPRDate`, `MaritalStatus`, " +
"`PresentAddress`, `PermanentAddress`, `OfficeAddress`, `PersonalPhoneNumber`, " +
"`EmailAddress`) VALUES " +
"(@BANumber, @FullName, @Appointment, @PlateName, @ServiceStatus, " +
"@RankId, @Sex, @Unit, @JoiningDate, @LPRDate, @MaritalStatus, " +
"@PresentAddress, @PermanentAddress, @OfficeAddress, @PersonalPhoneNumber, " +
"@EmailAddress);";
Hashtable aHashtable = new Hashtable()
{
{"BANumber", aTelephoneUserInfo.BANumber},
{"FullName", aTelephoneUserInfo.FullName},
{"Appointment", aTelephoneUserInfo.Appointment},
{"PlateName", aTelephoneUserInfo.PlateName},
{"ServiceStatus", aTelephoneUserInfo.ServiceStatus},
{"RankId", aTelephoneUserInfo.RankID},
{"Sex", aTelephoneUserInfo.Sex},
{"Unit", aTelephoneUserInfo.Unit},
{"JoiningDate", aTelephoneUserInfo.JoiningDate.ToString("yyyy-MM-dd")},
{"LPRDate", aTelephoneUserInfo.LPRDate.ToString("yyyy-MM-dd")},
{"MaritalStatus", aTelephoneUserInfo.MaritalStatus},
{"PresentAddress", aTelephoneUserInfo.PresentAddress},
{"PermanentAddress", aTelephoneUserInfo.PermanentAddress},
{"OfficeAddress", aTelephoneUserInfo.OfficeAddress},
{"PersonalPhoneNumber", aTelephoneUserInfo.PersonalPhoneNumber},
{"EmailAddress", aTelephoneUserInfo.EmailAddress},
};
aGateway.Insert(nonQuery, aHashtable);
}