public string Insert(QuestionnaireMasterData data)
{
string sqlStr, qPk;
SqlCommand cmd;
sqlStr = @"Insert Into QuestionnaireMaster(category,heading,description,createDate,startDate,endDate,status, comment,OneTime) Values(@category,@heading,@description,@createDate,@startDate,@endDate,@status, @comment, @OneTime) SET @QPk = SCOPE_IDENTITY()";
cmd = new SqlCommand(sqlStr, this.mCon);
cmd.Parameters.AddWithValue("@category", data.Category);
cmd.Parameters.AddWithValue("@heading", data.Heading);
cmd.Parameters.AddWithValue("@description", data.Description);
cmd.Parameters.AddWithValue("@createDate", data.CreateDate);
cmd.Parameters.AddWithValue("@startDate", data.StartDate);
cmd.Parameters.AddWithValue("@endDate", data.EndDate);
cmd.Parameters.AddWithValue("@status", data.Status);
cmd.Parameters.AddWithValue("@comment", data.Comment);
cmd.Parameters.AddWithValue("@OneTime", data.OneTime ? "Y" : "N");
var para = new SqlParameter("@QPk", System.Data.SqlDbType.Int);
para.Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(para);
this.mCon.Open();
cmd.ExecuteNonQuery();
this.mCon.Close();
cmd.Dispose();
qPk = para.Value.ToString();
return(qPk);
}
private QuestionnaireMasterData GetQuestionnaireMaster(SqlDataReader dr)
{
QuestionnaireMasterData data = new QuestionnaireMasterData();
data.Id = ((int)(dr["id"]));
data.Category = dr["category"].ToString();
data.Heading = dr["heading"].ToString();
data.Description = dr["description"].ToString();
data.CreateDate = ((System.DateTime)(dr["createDate"]));
data.UpdateTime = dr["updateTime"].Equals(DBNull.Value) ? DateTime.MaxValue : (DateTime)dr["updateTime"];
data.StartDate = ((System.DateTime)(dr["startDate"]));
data.EndDate = ((System.DateTime)(dr["endDate"]));
data.Status = dr["status"].ToString();
data.Comment = dr["comment"].ToString();
data.OneTime = dr["OneTime"].ToString() == "Y";
return(data);
}
public virtual void Update(QuestionnaireMasterData data)
{
string sqlStr;
SqlCommand cmd;
sqlStr = @"Update QuestionnaireMaster Set category= @category,heading= @heading,description= @description,updateTime= @updateTime,startDate= @startDate,endDate= @endDate,status= @status, comment= @comment, OneTime=@OneTime Where id =@id";
cmd = new SqlCommand(sqlStr, this.mCon);
cmd.Parameters.AddWithValue("@category", data.Category);
cmd.Parameters.AddWithValue("@heading", data.Heading);
cmd.Parameters.AddWithValue("@description", data.Description);
cmd.Parameters.AddWithValue("@updateTime", data.UpdateTime);
cmd.Parameters.AddWithValue("@startDate", data.StartDate);
cmd.Parameters.AddWithValue("@endDate", data.EndDate);
cmd.Parameters.AddWithValue("@status", data.Status);
cmd.Parameters.AddWithValue("@comment", data.Comment);
cmd.Parameters.AddWithValue("@OneTime", data.OneTime ? "Y" : "N");
cmd.Parameters.AddWithValue("@id", data.Id);
this.mCon.Open();
cmd.ExecuteNonQuery();
this.mCon.Close();
cmd.Dispose();
}
