public int SaveOrganizationInfo(Models.BldOrganizationInfo aInfo)
{
int rowAffected = 0;
string query = "INSERT INTO BldOrganizationInfo VALUES('" + aInfo.OrganizationName + "', '" + aInfo.Address + "', '" + aInfo.Mobile + "', '" + aInfo.Email + "','" + aInfo.DivisionInfoId + "','" + aInfo.DistrictInfoId + "', GETDATE() )";
Connection.Open();
Command = new SqlCommand(query, Connection);
rowAffected = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffected);
}
public string SaveOrganizationInfo(Models.BldOrganizationInfo aInfo)
{
bool isDuplicateExist = _bldOrganizationGateway.IsExist(aInfo);
if (!isDuplicateExist)
{
int rowAffected = _bldOrganizationGateway.SaveOrganizationInfo(aInfo);
if (rowAffected > 0)
{
return("success");
}
else
{
return("failed");
}
}
else
{
return("exist");
}
}
protected void OrganizationSaveButton_Click(object sender, EventArgs e)
{
string a = organizationNameTextBox.Text.Trim();
string b = addressTextBox.Text.Trim();
string c = mobileTextBox.Text.Trim();
string d = emailTextBox.Text.Trim();
string es = divisionNameDropDownList.SelectedValue;
string f = districtNameDropDownList.SelectedValue;
if (!string.IsNullOrEmpty(a) && !string.IsNullOrEmpty(b) && !string.IsNullOrEmpty(c) && !string.IsNullOrEmpty(es) && !string.IsNullOrEmpty(f))
{
Models.BldOrganizationInfo aInfo = new Models.BldOrganizationInfo();
aInfo.OrganizationName = a;
aInfo.Address = b;
aInfo.Mobile = c;
aInfo.Email = d;
aInfo.DivisionInfoId = Convert.ToInt32(es);
aInfo.DistrictInfoId = Convert.ToInt32(f);
string msg = _bldOrganizationManager.SaveOrganizationInfo(aInfo);
if (msg == "success")
{
DisplayMessage("Save Successfully.", Color.ForestGreen);
}
else if (msg == "failed")
{
DisplayMessage("Failed! Try Again.", Color.DarkRed);
}
else if (msg == "exist")
{
DisplayMessage("Duplicate Data Exist! Try Again.", Color.Red);
}
}
else
{
DisplayMessage("Empty Fields Are Required!", Color.Red);
}
}
