hey guys...i want to improve my skills and that is why i develop a project by using multilayer project..but i have a problem which is i cant understand the logic how i will interact DAL layer and Helper layer...i try to add the datas with stored procedure which is like that
ALTER procedure [dbo].[sp_AddDatas]
(
@firmanin_adi nvarchar(70),
@firmanin_adresi nvarchar(max),
@yetkili_ismi nvarchar(50),
@firmanin_email nvarchar(50),
@firmanin_email2 nvarchar(50),
@referans_bilgisi nvarchar(max),
@ntlar_aciklmlar nvarchar(max),
@gsm_num1 nvarchar(20),
@gsm_num2 nvarchar(20),
@sbt_num nvarchar(20)
)
as
BEGIN
Set Nocount On
Declare @id int
Select @id =id From Firmalar where firma_adi=@firmanin_adi
If isnull (@id,0)=0
Begin
Insert Into Firmalar (firma_adi,adres,yetkili_ad,email,email2,referans,not_aciklama) Values (@firmanin_adi,@firmanin_adresi,@yetkili_ismi,@firmanin_email,@firmanin_email2,@referans_bilgisi,@ntlar_aciklmlar)
Select @id=@@Identity
Insert Into Telefon (gsm1,gsm2,numara,yetkili_ad,firma_id) Values (@gsm_num1,@gsm_num2,@sbt_num,@yetkili_ismi,@id)
End
Else
Begin
Insert Into Telefon (gsm1,gsm2,numara,yetkili_ad,firma_id) Values (@gsm_num1,@gsm_num2,@sbt_num,@yetkili_ismi,@id)
End
END
i wrote a method in my Helper class to interact with that procedure like below
public void InsertDatas(Firmalar firma)
{
frm = new FirmaEklemeFormu();
SqlDataReader dr = d.InsertData();
firma.firma_adi = frm.txtFirma_adi.Text;
firma.adres = frm.txtAdres.Text;
firma.yetkili_ad = frm.txtYetkili_adi.Text;
firma.email = frm.txtEmail.Text;
firma.email2 = frm.txtEmail2.Text;
firma.referans = frm.txtReferans.Text;
firma.not_aciklama = frm.txtNot_aciklama.Text;
}
but i have some other parameters for my stored procedure in another form...i dont know how i can add that data in multilayer design or am i in the right way...i need help guys
Loading
Gomathi PalaniswamyPosted Oct 12, 2010, 6:12 AM
i have written example sp below.refer it
connection.con.Open();
string id = connection.GetID("CreateAccount");
SqlCommand oc = new SqlCommand("create1", connection.con);
oc.CommandType = CommandType.StoredProcedure;
string accno="BOI"+branch.Text+id;
oc.Parameters.AddWithValue("@Date", DateTime.Now.ToString());
oc.Parameters.AddWithValue("@Branch", branch.Text);
oc.Parameters.AddWithValue("@Name", Name.Text);
oc.Parameters.AddWithValue("@DateofBirth", dob.Text);
oc.Parameters.AddWithValue("@Qualification", TextBox3.Text);
if (Home.Checked == true)
{
str = "home";
}
if (land.Checked == true)
{
str = str + "land";
}
if (Vehicle.Checked == true)
{
str = str + "vehicle";
}
oc.Parameters.AddWithValue("@PropertyDetails", str.ToString());
oc.Parameters.AddWithValue("@Email", Email.Text);
oc.Parameters.AddWithValue("@CurrentCity", currentcity.Text);
oc.Parameters.AddWithValue("@Years", years.Text);
oc.Parameters.AddWithValue("@Address", address.Text);
oc.Parameters.AddWithValue("@Occupation", occupation.Text);
oc.Parameters.AddWithValue("@MonthlyIncome", monthlyincome.Text);
oc.Parameters.AddWithValue("@AccountType", Accounttype.Text);
oc.Parameters.AddWithValue("@ContactNo", contactno.Text);
byte[] imagedata = new byte[FileUpload1.PostedFile.ContentLength];
oc.Parameters.AddWithValue("@Photo", imagedata);
oc.Parameters.AddWithValue("@Legalguadian", legalgau.Text);
oc.Parameters.AddWithValue("@Guadianaddress", gaddress.Text);
oc.Parameters.AddWithValue("@accno", accno.ToString());
oc.Parameters.AddWithValue("@deposit", TextBox1.Text);
oc.ExecuteNonQuery();
MessageBox.Show("You have created account Successfully");
connection.con.Close();