public RESPONSE_MODEL AddApplication(APPLICATIONS source)
{
try
{
APPLICATIONS application = new APPLICATIONS();
application.APP_NAME = source.APP_NAME;
application.APP_CODE = source.APP_CODE;
application.APP_DESCRIPTION = source.APP_DESCRIPTION;
application.APP_STATUS = source.APP_STATUS;
application.APP_URL = source.APP_URL;
ctx.APPLICATIONS.Add(application);
APPLICATION_MENUS menu = new APPLICATION_MENUS();
menu.APP_ID = application.APP_ID;
menu.MENU_LEVEL = 0;
menu.MENU_SEQ = 0;
menu.MENU_STATUS = 1;
menu.MENU_NAME = "Home";
ctx.APPLICATION_MENUS.Add(menu);
ctx.SaveChanges();
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
//create a appoinment
public Boolean createAppointments(Appoinment appoinment)
{
//lista.Add(appoinment);
APPLICATIONS newAPPLICATIONS = new APPLICATIONS();
//newAPPLICATIONS.doctor_id= appoinment.
LinqToSQL.insert2applications(newAPPLICATIONS);
return true;
}
///<summary>
///APPLICATIONS
/// </summary>
public static void insert2applications(APPLICATIONS newAPPLICATIONS)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Add new APPLICATIONS to database
db.APPLICATIONS.InsertOnSubmit(newAPPLICATIONS);
//Save changes to Database.
db.SubmitChanges();
}
public static void updateAPPLICATIONS(string str_id, APPLICATIONS newapplication)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get application for update
APPLICATIONS oldapplication = db.APPLICATIONS.FirstOrDefault(e => e.id.Equals(str_id));
oldapplication = newapplication;
//Save changes to Database.
db.SubmitChanges();
}
public static void deleteapplication(string str_id)
{
string connectString = System.Configuration.ConfigurationManager.ConnectionStrings["LinqToSQLDBConnectionString"].ToString();
ECMSDataContext db = new ECMSDataContext(connectString);
//Get APPLICATIONS to Delete
APPLICATIONS deleteAPPLICATIONS = db.APPLICATIONS.FirstOrDefault(e => e.id.Equals(str_id));
//Delete APPLICATIONS
db.APPLICATIONS.DeleteOnSubmit(deleteAPPLICATIONS);
//Save changes to Database.
db.SubmitChanges();
}
public RESPONSE_MODEL UpdateApplication(APPLICATIONS source)
{
try
{
var application = ctx.APPLICATIONS.Where(o => o.APP_ID == source.APP_ID).FirstOrDefault();
application.APP_NAME = source.APP_NAME;
application.APP_CODE = source.APP_CODE;
application.APP_DESCRIPTION = source.APP_DESCRIPTION;
application.APP_STATUS = source.APP_STATUS;
application.APP_URL = source.APP_URL;
ctx.SaveChanges();
}
catch (Exception ex)
{
resp = ErrorCollection(ex);
}
return(resp);
}
public JsonResult UpdateApplication(APPLICATIONS source)
{
resp = appService.UpdateApplication(source);
return(Json(resp, JsonRequestBehavior.AllowGet));
}
