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); }