public string Insert(QuestionnaireAnswerMData data) { string sqlStr, answerPK; SqlCommand cmd; SqlParameter para; sqlStr = "Insert Into QuestionnaireAnswerM(masterId,step,st" + "atus) Values(@masterId,@step,@st" + "atus) SET @AnswerPK = SCOPE_IDENTITY()"; cmd = new SqlCommand(sqlStr, this.mCon); cmd.Parameters.AddWithValue("@masterId", data.MasterId); cmd.Parameters.AddWithValue("@step", data.Step); cmd.Parameters.AddWithValue("@status", data.Status); para = new SqlParameter("@AnswerPK", System.Data.SqlDbType.Int); para.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(para); this.mCon.Open(); cmd.ExecuteNonQuery(); this.mCon.Close(); cmd.Dispose(); answerPK = para.Value.ToString(); return(answerPK); }
private QuestionnaireAnswerMData GetQuestionnaireAnswerM(SqlDataReader dr) { QuestionnaireAnswerMData data = new QuestionnaireAnswerMData(); data.Id = ((int)(dr["id"])); data.MasterId = dr["masterId"].ToString(); data.Step = ((int)(dr["step"])); data.Status = dr["status"].ToString(); return(data); }
public virtual void Update(QuestionnaireAnswerMData data) { string sqlStr; SqlCommand cmd; sqlStr = "Update QuestionnaireAnswerM Set " + "masterId= @masterId,step= @step,status= @status " + " Where id =@id"; cmd = new SqlCommand(sqlStr, this.mCon); cmd.Parameters.AddWithValue("@masterId", data.MasterId); cmd.Parameters.AddWithValue("@step", data.Step); cmd.Parameters.AddWithValue("@status", data.Status); cmd.Parameters.AddWithValue("@id", data.Id); this.mCon.Open(); cmd.ExecuteNonQuery(); this.mCon.Close(); cmd.Dispose(); }