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