public FormInstanceModel GetFormInstanceById(Int64 formInstanceId) { using (var conn = new SqlConnection(ConnectionString)) { var cmd = new SqlCommand("[dbo].[SP_GETFormInstanceById]", conn) { CommandType = CommandType.StoredProcedure }; var param = new SqlParameter { ParameterName = "@FormInstanceId", Value = formInstanceId, SqlDbType = SqlDbType.BigInt }; cmd.Parameters.Add(param); conn.Open(); var da = new SqlDataAdapter(cmd); var ds = new DataSet(); da.Fill(ds, "FormInstance"); conn.Close(); var tempData = FormInstanceModeMapping.MapDataTableToFormTemplateModel(ds); return(tempData); } }
public FormInstanceModel InsertOrUpdateFormInstance(FormInstanceModel instanceModel) { using (var conn = new SqlConnection(ConnectionString)) { var cmd = new SqlCommand("[dbo].[SP_AddOrUpdateFormInstance]", conn) { CommandType = CommandType.StoredProcedure }; var param = new SqlParameter { ParameterName = "@FormInstanceId", Value = instanceModel.FormInstanceId, SqlDbType = SqlDbType.BigInt }; cmd.Parameters.Add(param); param = new SqlParameter { ParameterName = "@FormDataFields", Value = instanceModel.FormData, SqlDbType = SqlDbType.NVarChar }; cmd.Parameters.Add(param); param = new SqlParameter { ParameterName = "@FormTemplateId", Value = instanceModel.FormTemplateId, SqlDbType = SqlDbType.BigInt }; cmd.Parameters.Add(param); conn.Open(); var da = new SqlDataAdapter(cmd); var ds = new DataSet(); da.Fill(ds, "FormTemplate"); conn.Close(); var tempData = FormInstanceModeMapping.MapDataTableToFormTemplateModel(ds); conn.Close(); return(tempData); } }