protected void btn_create_table_Click(object sender, EventArgs e)
{
string websitename = "";
string databasename = "";
string tablename = txt_table_name.Text.Trim();
string columnname = (Session["column"] != null ? Session["column"].ToString() : "");
string datatype = (Session["datatype"] != null ? Session["datatype"].ToString() : "");
if (columnname != "")
{
columnname = columnname.Remove(columnname.Length - 1, 1);
}
if (datatype != "")
{
datatype = datatype.Remove(datatype.Length - 1, 1);
}
string query = "";
if (Session["column_details"] != null)
{
query = Session["column_details"].ToString();
query = query.Remove(query.Length - 1, 1);
}
Guid userid;
System.Web.Security.MembershipUser mu;
mu = System.Web.Security.Membership.GetUser();
userid = (Guid)mu.ProviderUserKey;
var q = dbmanagement.GetDatabaseListByDbId(Convert.ToInt32(hf_db_id_for_tbl.Value));
if (q.Any())
{
foreach (var a in q)
{
websitename = a.WebsiteName;
databasename = a.DatabaseName;
}
}
string path = Server.MapPath("~/web-design/" + Session[Constants.Session.USERNAME].ToString() + "/" + websitename + "/" + "App_Data/" + databasename + ".mdf");
bool exists = System.IO.File.Exists(path);
if (exists)
{
SqlConnection myConn = new SqlConnection(@"Data Source=(LocalDB)\v11.0;AttachDbFilename='" + path + "';Integrated Security=True");
string str = "create table " + tablename + "(" + query + ")";
SqlCommand myCommand = new SqlCommand(str, myConn);
try
{
// saving table details in database------------------
if (dbmanagement.SaveTable(tablename, Convert.ToInt32(hf_db_id_for_tbl.Value), websitename, Session[Constants.Session.USERNAME].ToString(), userid))
{
myConn.Open();
myCommand.ExecuteNonQuery();
dbmanagement.SaveTableColumnDetails(Convert.ToInt32(hf_db_id_for_tbl.Value), tablename, columnname, datatype, userid);
ClearManageTableData();
lbl_create_table_msg.ForeColor = System.Drawing.Color.Green;
lbl_create_table_msg.Text = "Table created successfully.";
}
else
{
lbl_create_table_msg.ForeColor = System.Drawing.Color.Red;
lbl_create_table_msg.Text = "Could not created.";
}
//---------------------------
}
catch
{
lbl_create_table_msg.ForeColor = System.Drawing.Color.Red;
lbl_create_table_msg.Text = "Could not created.";
int tableid = dbmanagement.GetTableId(Convert.ToInt32(hf_db_id_for_tbl.Value), websitename, userid);
if (tableid != 0)
{
dbmanagement.DeleteTableByTableId(tableid);
}
}
finally
{
Session["column_details"] = null;
Session["column"] = null;
Session["datatype"] = null;
}
}
else
{
lbl_create_table_msg.ForeColor = System.Drawing.Color.Red;
lbl_create_table_msg.Text = "Database does not exist.";
}
Session["column_details"] = null;
Session["column"] = null;
Session["datatype"] = null;
//string db_path = "~/web-design/" + Session[Constants.Session.USERNAME].ToString() + "/" + websitename + "/" + "App_Data/";
//bool exists = System.IO.Directory.Exists(Server.MapPath(db_path));
}
