public long registrationSme(SME regisInsert)
{
long sid = 0;
SqlConnection connect = ConnectionHandler.getConnection();
connect.Open();
SqlCommand cmd = new SqlCommand("insert into sme values (@First_name,@Last_name,@gender,@contact_no,@age,@userid,@password,@userType,@emailId,@description)", connect);
SqlCommand cmd2 = new SqlCommand("select * from sme where userid=@userID", connect);
cmd2.Parameters.AddWithValue("@userID", regisInsert.Userid);
cmd.Parameters.AddWithValue("@First_name", regisInsert.First_name);
cmd.Parameters.AddWithValue("@Last_name", regisInsert.Last_name);
cmd.Parameters.AddWithValue("@gender", regisInsert.Gender);
cmd.Parameters.AddWithValue("@contact_no", regisInsert.Contact_no);
cmd.Parameters.AddWithValue("@age", regisInsert.Age);
cmd.Parameters.AddWithValue("@userid", regisInsert.Userid);
string encpassword = encrypt(regisInsert.Password_user);
cmd.Parameters.AddWithValue("@password", encpassword);
cmd.Parameters.AddWithValue("@userType", regisInsert.UserType);
cmd.Parameters.AddWithValue("@emailId", regisInsert.EmailId);
cmd.Parameters.AddWithValue("@description", regisInsert.Description);
cmd.ExecuteNonQuery();
SqlDataReader dr = cmd2.ExecuteReader();
while (dr.Read())
{
sid = long.Parse(dr["smeId"].ToString());
}
connect.Close();
return(sid);
}
public List <SME> SelectAll()
{
List <SME> list = new List <SME>();
this.DataProvider.ExecuteCmd("dbo.SME_SelectAll"
, inputParamMapper : null
, singleRecordMapper : delegate(IDataReader reader, short set)
{
SME singleItem = Mapper(reader);
list.Add(singleItem);
});
return(list);
}
private SME Mapper(IDataReader reader)
{
SME singleItem = new SME();
int startingIndex = 0; //startingOrdinal
singleItem.Id = reader.GetSafeInt32(startingIndex++);
singleItem.CreatedDate = reader.GetSafeDateTime(startingIndex++);
singleItem.ModifiedDate = reader.GetSafeDateTime(startingIndex++);
singleItem.ModifiedBy = reader.GetSafeString(startingIndex++);
singleItem.MaxInteractionsPer1k = reader.GetSafeDecimal(startingIndex++);
singleItem.MinInteractionsPer1k = reader.GetSafeDecimal(startingIndex++);
singleItem.SumInteractionsPer1k = reader.GetSafeDecimal(startingIndex++);
return(singleItem);
}
public SME SelectById(int id)
{
SME singleItem = null;
this.DataProvider.ExecuteCmd("dbo.SME_SelectByID"
, inputParamMapper : delegate(SqlParameterCollection paramCollection)
{
paramCollection.AddWithValue("@Id", id);
}
, singleRecordMapper : delegate(IDataReader reader, short set)
{
singleItem = Mapper(reader);
});
return(singleItem);
}
public SME getSme(long smeId)
{
SME sme = null;
using (SqlConnection connection = ConnectionHandler.getConnection())
{
connection.Open();
SqlCommand getSme = new SqlCommand("Select *from sme where smeId=@smeId", connection);
getSme.Parameters.AddWithValue("@smeId", smeId);
SqlDataReader result = getSme.ExecuteReader();
while (result.Read())
{
sme = new SME(long.Parse(result["smeId"].ToString()), result["first_name"].ToString(), result["last_name"].ToString(), result["gender"].ToString(), long.Parse(result["contact_no"].ToString()), long.Parse(result["age"].ToString()), result["userid"].ToString(), result["password_user"].ToString(), result["userType"].ToString(), result["emailId"].ToString(), result["description"].ToString());
}
connection.Close();
}
return(sme);
}
protected long sme()
{
long sid = 0;
registrationInsertion regis = new registrationInsertion();
SME smedetails = new SME();
if (usertype.Text == "SME")
{
smedetails.First_name = txtfirstname.Text;
smedetails.Last_name = txtlastname.Text;
smedetails.Gender = radiogender.Text;
smedetails.Age = long.Parse(txtage.Text);
smedetails.Contact_no = long.Parse(txtcontact.Text);
smedetails.Userid = txtuserid.Text;
smedetails.Password_user = txtpassword.Text;
smedetails.UserType = usertype.Text;
smedetails.EmailId = emailid.Text;
smedetails.Description = TextBox1.Text;
sid = regis.registrationSme(smedetails);
}
return(sid);
}
