public ActionResult Index(ProStoredProcedure proSP)
{
ViewBag.Title = "Home Page";
ViewBag.Name = "";
if (!string.IsNullOrWhiteSpace(proSP.Name))
{
ViewBag.Name = proSP.Name;
}
ViewBag.EXECUTE = "";
if (!string.IsNullOrWhiteSpace(proSP.Execute))
{
ViewBag.EXECUTE = proSP.Execute;
}
ViewBag.content = "";
if (!string.IsNullOrWhiteSpace(proSP.Content))
{
ViewBag.content = proSP.Content;
}
ViewBag.remark = "";
if (!string.IsNullOrWhiteSpace(proSP.Remark))
{
ViewBag.remark = proSP.Remark;
}
ViewBag.tags = "";
if (!string.IsNullOrWhiteSpace(proSP.Tags))
{
ViewBag.tags = proSP.Tags;
}
ViewBag.AJAXparams = getAJAXparams(proSP);
return(View());
}
// GET api/values/5
public object Get(int id)
{
Exception exception = null;
ProStoredProcedure proSP = null;
using (SQLPro db = new SQLPro())
{
try
{
proSP = db.ProStoredProcedure.Find(id);
}
catch (Exception ex)
{
exception = ex;
}
}
if (exception == null && proSP != null)
{
return(proSP);
}
else
{
return(exception);
}
}
// PUT api/values/5
public object Put([FromBody] ProStoredProcedure proSPNew)
{
proSPNew.Name = proSPNew.Name.Trim();
proSPNew.Execute = proSPNew.Execute.Trim();
Exception exception = null;
DateTime dNow = DateTime.Now;
using (SQLPro db = new SQLPro())
{
try
{
ProStoredProcedure proSP = db.ProStoredProcedure.Find(proSPNew.Id);
if (proSP != null)
{
if (!string.IsNullOrEmpty(proSPNew.Name))
{
proSP.Name = proSPNew.Name;
}
if (!string.IsNullOrEmpty(proSPNew.Execute))
{
proSP.Execute = proSPNew.Execute;
}
if (!string.IsNullOrEmpty(proSPNew.Content))
{
proSP.Content = proSPNew.Content;
}
if (!string.IsNullOrEmpty(proSPNew.Remark))
{
proSP.Remark = proSPNew.Remark;
}
if (!string.IsNullOrEmpty(proSPNew.Tags))
{
proSP.Tags = proSPNew.Tags;
}
db.SaveChanges();
}
}
catch (Exception ex)
{
exception = ex;
}
}
if (exception == null)
{
return(new { msg = "COMMIT" });
}
else
{
return(exception);
}
}
// POST api/values
public object Post([FromBody] ProStoredProcedure proSP)
{
if (proSP == null)
{
return(new { msg = "proSP is null !!" });
}
else if (proSP.Name == null)
{
return(new { msg = "proSP.Name is null !!" });
}
else if (proSP.Execute == null)
{
return(new { msg = "proSP.Execute is null !!" });
}
proSP.Name = proSP.Name.Trim();
proSP.Execute = proSP.Execute.Trim();
Exception exception = null;
DateTime dNow = DateTime.Now;
proSP.CreatedTime = dNow;
proSP.UpdateTime = dNow;
using (SQLPro db = new SQLPro())
{
try
{
db.ProStoredProcedure.Add(proSP);
db.SaveChanges();
}
catch (Exception ex)
{
exception = ex;
}
}
if (exception == null)
{
return(new { msg = "COMMIT" });
}
else
{
return(exception);
}
}
private string getAJAXparams(ProStoredProcedure proSP)
{
List <string> aJAX_Params = new List <string>();
if (!string.IsNullOrWhiteSpace(proSP.Name))
{
aJAX_Params.Add("Name=" + proSP.Name);
}
if (!string.IsNullOrWhiteSpace(proSP.Execute))
{
if (string.IsNullOrWhiteSpace(proSP.Name))
{
aJAX_Params.Add("Name=");
}
aJAX_Params.Add("Execute=" + proSP.Execute);
}
if (!string.IsNullOrWhiteSpace(proSP.Content))
{
if (string.IsNullOrWhiteSpace(proSP.Name))
{
aJAX_Params.Add("Name=");
}
if (string.IsNullOrWhiteSpace(proSP.Execute))
{
aJAX_Params.Add("Execute=");
}
aJAX_Params.Add("Content=" + proSP.Content);
}
if (!string.IsNullOrWhiteSpace(proSP.Remark))
{
if (string.IsNullOrWhiteSpace(proSP.Name))
{
aJAX_Params.Add("Name=");
}
if (string.IsNullOrWhiteSpace(proSP.Execute))
{
aJAX_Params.Add("Execute=");
}
if (string.IsNullOrWhiteSpace(proSP.Content))
{
aJAX_Params.Add("Content=");
}
aJAX_Params.Add("Remark=" + proSP.Remark);
}
if (!string.IsNullOrWhiteSpace(proSP.Tags))
{
if (string.IsNullOrWhiteSpace(proSP.Name))
{
aJAX_Params.Add("Name=");
}
if (string.IsNullOrWhiteSpace(proSP.Execute))
{
aJAX_Params.Add("Execute=");
}
if (string.IsNullOrWhiteSpace(proSP.Content))
{
aJAX_Params.Add("Content=");
}
if (string.IsNullOrWhiteSpace(proSP.Remark))
{
aJAX_Params.Add("Remark=");
}
aJAX_Params.Add("Tags=" + proSP.Tags);
}
if (aJAX_Params.Count > 0)
{
return("?" + string.Join("&", aJAX_Params));
}
else
{
return("");
}
}