private Form_Template_Design SaveFormTemplateDesign(Form_Template_Design Form_Template_Design)
{
db.Form_Template_Design.Add(Form_Template_Design);
db.SaveChanges();
return Form_Template_Design;
}
private static void AppendAddColumnStatement(string dynamicTableName, StringBuilder addColumns, Form_Template_Design designElement)
{
if (string.IsNullOrEmpty(dynamicTableName) || string.IsNullOrEmpty(designElement.Data_Field_Name) || string.IsNullOrEmpty(designElement.Data_Field_Type))
return; // To handle 'Label' cases - because these controls would not have any data template columns
//throw new ApplicationException(string.Format("Invalid data in anyone of these, SurveyTypeName [{0}] - SurveyTypeName [{1}] - SurveyTypeName [{2}]",
// dynamicTableName, designElement.Data_Field_Name, designElement.Data_Field_Type));
addColumns.AppendLine("IF NOT EXISTS(SELECT * FROM sys.columns WHERE Name = N'" + designElement.Data_Field_Name +
"' AND Object_ID = Object_ID(N'" + dynamicTableName + "'))");
addColumns.AppendLine("ALTER TABLE [dbo].[" + dynamicTableName + "] ADD [" + designElement.Data_Field_Name + "] " + designElement.Data_Field_Type + " NULL;");
}
private static void AppendAlterColumnStatement(string dynamicTableName, StringBuilder addColumns, Form_Template_Design designElement)
{
if (string.IsNullOrEmpty(dynamicTableName) || string.IsNullOrEmpty(designElement.Data_Field_Name) || string.IsNullOrEmpty(designElement.Data_Field_Type))
return;
addColumns.AppendLine("IF EXISTS(SELECT * FROM sys.columns WHERE Name = N'" + designElement.Data_Field_Name +
"' AND Object_ID = Object_ID(N'" + dynamicTableName + "'))");
addColumns.AppendLine("ALTER TABLE [dbo].[" + dynamicTableName + "] ALTER COLUMN [" + designElement.Data_Field_Name + "] " + designElement.Data_Field_Type + " NULL;");
}
public IHttpActionResult PutForm_Template_Design(int id, Form_Template_Design Form_Template_Design)
{
if (!ModelState.IsValid)
{
return BadRequest(ModelState);
}
if (id != Form_Template_Design.Form_Field_ID)
{
return BadRequest();
}
db.Entry(Form_Template_Design).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!Form_Template_DesignExists(id))
{
return NotFound();
}
else
{
throw;
}
}
return StatusCode(HttpStatusCode.NoContent);
}
