public int AddUser(BeAddUser a)
{
InsertUser obj = new InsertUser();
int error = obj.Insert(a);
return(error);
}
public DataTable UpdateState(BeAddUser obj)
{
var connectionString = ConfigurationManager.ConnectionStrings["BusResSysConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand cmd = new SqlCommand("usp_UpdateState", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@count", obj.Country);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
try
{
return(dt);
}
catch
{
throw;
}
finally
{
con.Close();
con.Dispose();
}
}
public DataTable tblCountry()
{
BeAddUser obj1 = new BeAddUser();
BalClass obj = new BalClass();
DataTable dt = obj.UpdateCountry();
return(dt);
}
public DataTable tblcity(string state)
{
BeAddUser obj1 = new BeAddUser();
BalClass obj = new BalClass();
obj1.State = state;
DataTable dt = obj.UpdateCity(obj1);
return(dt);
}
public DataTable tblstate(string count)
{
BeAddUser obj1 = new BeAddUser();
BalClass obj = new BalClass();
obj1.Country = count;
DataTable dt = obj.UpdateState(obj1);
return(dt);
}
public int Insert(BeAddUser a)
{
var connectionString = ConfigurationManager.ConnectionStrings["BusResSysConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(connectionString);
con.Open();
SqlCommand cmd = new SqlCommand("usp_InsertUser", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@uid", a.uid);
cmd.Parameters.AddWithValue("@name", a.Name);
cmd.Parameters.AddWithValue("@address", a.Address);
cmd.Parameters.AddWithValue("@city", a.City);
cmd.Parameters.AddWithValue("@state", a.State);
cmd.Parameters.AddWithValue("@country", a.Country);
cmd.Parameters.AddWithValue("@pincode", a.PinCode);
cmd.Parameters.AddWithValue("@email", a.Email);
cmd.Parameters.AddWithValue("@contact", a.Contact);
cmd.Parameters.AddWithValue("@dob", a.Dob);
cmd.Parameters.AddWithValue("@gender", a.Gender);
try
{
cmd.ExecuteNonQuery();
return(1);
}
catch
{
return(-1);
throw;
}
finally
{
con.Close();
con.Dispose();
}
}
protected void BtnAddSubmit_Click(object sender, EventArgs e)
{
BeAddUser a = new BeAddUser();
BalClass b = new BalClass();
char gender;
if (RdoAddMale.Checked)
{
gender = 'M';
}
else if (RdoAddFemale.Checked)
{
gender = 'F';
}
else
{
gender = 'O';
}
if (gender != 'O')
{
Random rnd = new Random();
int num = rnd.Next(1000, 9999);
DateTime dt = DateTime.Now;
string[] date = dt.ToString("MM/dd/yyyy").Split(' ');
a.uid = Convert.ToInt64(date[0].Substring(6, 4) + date[0].Substring(0, 2) + num.ToString());
a.Name = TxtAddName.Text.Trim();
a.Address = TxtAddAddress.Text.Trim();
a.Country = LstAddCountry.SelectedItem.ToString();
a.State = LstAddState.SelectedItem.ToString();
a.City = LstAddCity.SelectedItem.ToString();
a.PinCode = Convert.ToInt64(TxtAddPin.Text.Trim());
a.Email = TxtAddEmail.Text.Trim();
a.Contact = Convert.ToInt64(TxtAddContact.Text.Trim());
a.Dob = Convert.ToDateTime(TxtAddDob.Text.Trim());
a.Gender = gender;
int error = b.AddUser(a); //passing BE to BAL layer
if (error == 1)
{
string script = "alert('User Added Successfully !!');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", script, true);
Session["a_uid"] = a.uid;
Response.Redirect("Success.aspx");
}
else
{
string script = "alert('User could not be added !! Check Database Connection !!');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", script, true);
}
}
else
{
string script = "alert('Gender needs to be filled !!');";
Page.ClientScript.RegisterStartupScript(this.GetType(), "Alert", script, true);
}
}
} //fetching state from database
public DataTable UpdateCity(BeAddUser obj)
{
DataTable dt1 = obj2.UpdateCity(obj);
return(dt1);
} //fetching city from table
public DataTable UpdateState(BeAddUser obj)
{
DataTable dt = obj2.UpdateState(obj);
return(dt);
} //fetching state from database
