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