public bool CheckVisitorInfo(Visitor aVisitor,out string message)
{
if (aVisitor.Name == "")
{
message = "Name is not inserted";
return false;
}
else if (aVisitor.ContactNo == "")
{
message = "Contact Number is not inserted";
return false;
}
else if (aVisitor.Email == "")
{
message = "Email is not inserted";
return false;
}
else if (visitorGateway.IsEmailExist(aVisitor.Email))
{
message = "Email is exist";
return false;
}
else
{
message = "Saved visitor information Successfully";
return true;
}
}
public string Save(Visitor aVisitor,List<string> zoneVisit )
{
if (visitorGateway.SaveVisitorInformation(aVisitor,zoneVisit) > 0)
{
return " Successfully Save !";
}
else
{
return "Save Failed !";
}
}
public void LoadZoneTypeVisitor(ZoneType zoneName)
{
visitorDetails= new List<Visitor>();
visitorIdList = zoneManager.ZoneTypeVisitor(zoneName);
foreach (int id in visitorIdList)
{
Visitor aVisitor=new Visitor();
aVisitor = visitorManager.GetVisitorInfo(id);
visitorDetails.Add(aVisitor);
}
LoadDataGridView(visitorDetails);
}
public Visitor GetVisitorDetails(int visitorID)
{
Visitor visitorDetails=new Visitor();
dbGateway.SqlCommandObj.CommandText = "SELECT * FROM VisitorInfo_tbl WHERE ID='"+visitorID+"'";
dbGateway.SqlConnectionObj.Open();
SqlDataReader reader = dbGateway.SqlCommandObj.ExecuteReader();
while (reader.Read())
{
visitorDetails.Name = reader[1].ToString();
visitorDetails.Email = reader[2].ToString();
visitorDetails.ContactNo = reader[3].ToString();
}
reader.Close();
dbGateway.SqlConnectionObj.Close();
return visitorDetails;
}
public int SaveVisitorInformation(Visitor visitorInfo,List<string> zoneVisit )
{
dbGateway.SqlCommandObj.CommandText = "INSERT INTO VisitorInfo_tbl(Name,Email,Contact_No) VALUES('" + visitorInfo.Name + "','" + visitorInfo.Email + "','" + visitorInfo.ContactNo + "')";
dbGateway.SqlConnectionObj.Open();
int rowAffected = dbGateway.SqlCommandObj.ExecuteNonQuery();
dbGateway.SqlConnectionObj.Close();
int visitorId = GetVisitorID(visitorInfo.Email);
int zoneID = 0;
foreach (string zone in zoneVisit)
{
zoneID = zoneGateway.GetZoneID(zone);
relationship.SaveRelation(visitorId,zoneID);
}
return rowAffected;
}
private void saveButton_Click(object sender, EventArgs e)
{
Visitor aVisitor=new Visitor();
aVisitor.Name = nameTextBox.Text;
aVisitor.Email = emailTextBox.Text;
aVisitor.ContactNo = contactTextBox.Text;
List<string> visitorZoneTypeList= new List<string>();
if (!aVisitorManager.CheckVisitorInfo(aVisitor, out message))
{
MessageBox.Show(message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
for (int i = 1; i <= count; i++)
{
if (i == 1 && checkBox1.Checked == true)
{
visitorZoneTypeList.Add(checkBox1.Text);
}
else if (i == 2 && checkBox2.Checked == true)
{
visitorZoneTypeList.Add(checkBox2.Text);
}
else if (i == 3 && checkBox3.Checked == true)
{
visitorZoneTypeList.Add(checkBox3.Text);
}
else if (i == 4 && checkBox4.Checked == true)
{
visitorZoneTypeList.Add(checkBox4.Text);
}
else if (i == 5 && checkBox5.Checked == true)
{
visitorZoneTypeList.Add(checkBox5.Text);
}
else if (i == 6 && checkBox6.Checked == true)
{
visitorZoneTypeList.Add(checkBox6.Text);
}
}
aVisitorManager.Save(aVisitor, visitorZoneTypeList);
MessageBox.Show(message, "Successfully Saved", MessageBoxButtons.OK);
}
nameTextBox.Text = emailTextBox.Text = contactTextBox.Text = null;
zoneList = aZoneManager.ZoneList();
CheckZoneType(zoneList);
}