public ActionResult Delete(string id)
{
using (var session = DatabaseUtilities.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
try
{
EntityDB <ImmobiliModel> entityDb = new EntityDB <ImmobiliModel>();
string preQuery = "Delete from Immobili WHERE 1=1 AND id=@id";
SqlCommand preCommand = new SqlCommand(preQuery, session, transaction);
preCommand.Parameters.AddWithValue("@id", id);
preCommand.ExecuteNonQuery();
transaction.Commit();
var immobiliList = GetImmobiliList();
return(View("Immobili", immobiliList));
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static void Delete(int organisation_id)
{
try
{
Organisation o = OrganisationDB.GetByID(organisation_id);
if (o != null)
{
DBBase.ExecuteNonResult("DELETE FROM Organisation WHERE organisation_id = " + organisation_id.ToString());
if (EntityDB.NumForeignKeyDependencies(o.EntityID) == 0)
{
EntityDB.Delete(o.EntityID, false);
}
}
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
if (sqlEx.Errors.Count > 0 && sqlEx.Errors[0].Number == 547) // Assume the interesting stuff is in the first error
{
throw new ForeignKeyConstraintException(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name, sqlEx);
}
else
{
throw;
}
}
}
public static void Delete(int person_id)
{
try
{
Person p = PersonDB.GetByID(person_id);
if (p != null)
{
DBBase.ExecuteNonResult("DELETE FROM Person WHERE person_id = " + person_id.ToString() + "; DBCC CHECKIDENT(Person,RESEED,1); DBCC CHECKIDENT(Person);");
if (EntityDB.NumForeignKeyDependencies(p.EntityID) == 0)
{
EntityDB.Delete(p.EntityID, false);
}
}
}
catch (System.Data.SqlClient.SqlException sqlEx)
{
if (sqlEx.Errors.Count > 0 && sqlEx.Errors[0].Number == 547) // Assume the interesting stuff is in the first error
{
throw new ForeignKeyConstraintException(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.Name, sqlEx);
}
else
{
throw;
}
}
}
ActionResult Crea(ImmobiliModel immobile)
{
using (var session = DatabaseUtilities.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
try
{
EntityDB <ImmobiliModel> entityDb = new EntityDB <ImmobiliModel>();
string preQuery = "SELECT TOP 1 id FROM Immobili " +
" WHERE 1=1 ORDER BY id DESC";
// string preQuery = "SELECT * FROM Immobili " +
// " WHERE 1=1 ORDER BY id DESC LIMIT 1";
SqlCommand preCommand = new SqlCommand(preQuery, session, transaction);
SqlDataReader executeSqlDataReader = preCommand.ExecuteReader();
if (executeSqlDataReader.HasRows)
{
while (executeSqlDataReader.Read())
{
immobile.Id = long.Parse(executeSqlDataReader["Id"].ToString()) + 1;
}
}
else
{
immobile.Id = 1;
}
executeSqlDataReader.Close();
string query =
"INSERT INTO Immobili (Id, Nome, Descrizione, Mq, Prezzo, TipoImmobile, Posizione) VALUES (@id, @nome, @descrizione, @mq, @prezzo, @tipoImmobile, @posizione)";
SqlCommand command = new SqlCommand(query, session, transaction);
command.Parameters.AddWithValue("@id", immobile.Id);
command.Parameters.AddWithValue("@descrizione", immobile.Descrizione);
command.Parameters.AddWithValue("@nome", immobile.Nome);
if (!string.IsNullOrEmpty(immobile.Mq))
{
command.Parameters.AddWithValue("@mq", immobile.Mq);
}
else
{
command.Parameters.AddWithValue("@mq", DBNull.Value);
}
command.Parameters.AddWithValue("@prezzo", immobile.Prezzo);
command.Parameters.AddWithValue("@tipoImmobile", immobile.TipoImmobile);
command.Parameters.AddWithValue("@posizione", immobile.Posizione);
command.ExecuteNonQuery();
transaction.Commit();
var immobiliList = GetImmobiliList();
return(View("Immobili", immobiliList));
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
protected void Application_Start()
{
AreaRegistration.RegisterAllAreas();
RouteConfig.RegisterRoutes(RouteTable.Routes);
EntityDB entity = new EntityDB();
entity.Database.CreateIfNotExists();
}
public void efasync()
{
var ar = new[] { new { a = 1 }, new { a = 3 } };
using (var db = new EntityDB())
{
//
}
}
public ActionResult Edit(string id)
{
using (var session = DatabaseUtilities.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
try
{
EntityDB <ImmobiliModel> entityDb = new EntityDB <ImmobiliModel>();
string query = "select * from Immobili WHERE 1=1 AND id=@id";
SqlCommand command = new SqlCommand(query, session, transaction);
command.Parameters.AddWithValue("@id", id);
SqlDataReader executeSqlDataReader = command.ExecuteReader();
ImmobiliModel immobili = new ImmobiliModel();
while (executeSqlDataReader.Read())
{
var immobile = new ImmobiliModel()
{
Id = long.Parse(executeSqlDataReader["Id"].ToString()),
TipoImmobile = executeSqlDataReader["TipoImmobile"].ToString(),
Descrizione = executeSqlDataReader["Descrizione"].ToString(),
Mq = executeSqlDataReader["Mq"].ToString(),
Nome = executeSqlDataReader["Nome"].ToString(),
Posizione = executeSqlDataReader["Posizione"].ToString(),
Prezzo = executeSqlDataReader["Prezzo"].ToString()
};
List <PictureModel> pic = new List <PictureModel>();
string filepath = "~/Images/";
var path = Server.MapPath(filepath + immobile.Id);
DirectoryInfo d = new DirectoryInfo(path);
if (d.Exists)
{
foreach (var file in d.GetFiles())
{
pic.Add(new PictureModel()
{
name = file.Name,
image = System.IO.File.ReadAllBytes(file.FullName),
selected = file.Name.ToLowerInvariant().Contains("copertina") ? true : false
});
}
immobile.Picture = pic;
}
immobili = immobile;
}
executeSqlDataReader.Close();
return(View("ModifyImmobile", immobili));
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public static int Insert(int parent_organisation_id, bool use_parent_offernig_prices, int organisation_type_id, int organisation_customer_type_id, string name, string acn, string abn, bool is_debtor, bool is_creditor, string bpay_account, int weeks_per_service_cycle, DateTime start_date, DateTime end_date, string comment, int free_services, bool excl_sun, bool excl_mon, bool excl_tue, bool excl_wed, bool excl_thu, bool excl_fri, bool excl_sat, TimeSpan sun_start_time, TimeSpan sun_end_time, TimeSpan mon_start_time, TimeSpan mon_end_time, TimeSpan tue_start_time, TimeSpan tue_end_time, TimeSpan wed_start_time, TimeSpan wed_end_time, TimeSpan thu_start_time, TimeSpan thu_end_time, TimeSpan fri_start_time, TimeSpan fri_end_time, TimeSpan sat_start_time, TimeSpan sat_end_time, TimeSpan sun_lunch_start_time, TimeSpan sun_lunch_end_time, TimeSpan mon_lunch_start_time, TimeSpan mon_lunch_end_time, TimeSpan tue_lunch_start_time, TimeSpan tue_lunch_end_time, TimeSpan wed_lunch_start_time, TimeSpan wed_lunch_end_time, TimeSpan thu_lunch_start_time, TimeSpan thu_lunch_end_time, TimeSpan fri_lunch_start_time, TimeSpan fri_lunch_end_time, TimeSpan sat_lunch_start_time, TimeSpan sat_lunch_end_time, DateTime last_batch_run)
{
int entityID = EntityDB.Insert();
name = name.Replace("'", "''");
acn = acn.Replace("'", "''");
abn = abn.Replace("'", "''");
bpay_account = bpay_account.Replace("'", "''");
comment = comment.Replace("'", "''");
string sql = "INSERT INTO Organisation (entity_id,parent_organisation_id,use_parent_offernig_prices,organisation_type_id,organisation_customer_type_id,name,acn,abn,is_debtor,is_creditor,bpay_account,weeks_per_service_cycle,start_date,end_date,comment,free_services,excl_sun,excl_mon,excl_tue,excl_wed,excl_thu,excl_fri,excl_sat,sun_start_time,sun_end_time,mon_start_time,mon_end_time,tue_start_time,tue_end_time,wed_start_time,wed_end_time,thu_start_time,thu_end_time,fri_start_time,fri_end_time,sat_start_time,sat_end_time,sun_lunch_start_time,sun_lunch_end_time,mon_lunch_start_time,mon_lunch_end_time,tue_lunch_start_time,tue_lunch_end_time,wed_lunch_start_time,wed_lunch_end_time,thu_lunch_start_time,thu_lunch_end_time,fri_lunch_start_time,fri_lunch_end_time,sat_lunch_start_time,sat_lunch_end_time,last_batch_run) VALUES (" + entityID.ToString() + "," + (parent_organisation_id == 0 ? "NULL" : parent_organisation_id.ToString()) + "," + (use_parent_offernig_prices ? "1" : "0") + "," + organisation_type_id + "," + organisation_customer_type_id + ",'" + name + "'," + "'" + acn + "'," + "'" + abn + "'," + (is_debtor ? "1," : "0,") + (is_creditor ? "1," : "0,") + "'" + bpay_account + "'," + weeks_per_service_cycle + "," + (start_date == DateTime.MinValue ? "NULL" : "'" + start_date.ToString("yyyy-MM-dd HH:mm:ss") + "'") + "," + (end_date == DateTime.MinValue ? "NULL" : "'" + end_date.ToString("yyyy-MM-dd HH:mm:ss") + "'") + "," + "'" + comment + "'," + "" + free_services + "," + (excl_sun ? "1," : "0,") + (excl_mon ? "1," : "0,") + (excl_tue ? "1," : "0,") + (excl_wed ? "1," : "0,") + (excl_thu ? "1," : "0,") + (excl_fri ? "1," : "0,") + (excl_sat ? "1," : "0,") + "'" + sun_start_time.ToString() + "'," + "'" + sun_end_time.ToString() + "'," + "'" + mon_start_time.ToString() + "'," + "'" + mon_end_time.ToString() + "'," + "'" + tue_start_time.ToString() + "'," + "'" + tue_end_time.ToString() + "'," + "'" + wed_start_time.ToString() + "'," + "'" + wed_end_time.ToString() + "'," + "'" + thu_start_time.ToString() + "'," + "'" + thu_end_time.ToString() + "'," + "'" + fri_start_time.ToString() + "'," + "'" + fri_end_time.ToString() + "'," + "'" + sat_start_time.ToString() + "'," + "'" + sat_end_time.ToString() + "'," + "'" + sun_lunch_start_time.ToString() + "'," + "'" + sun_lunch_end_time.ToString() + "'," + "'" + mon_lunch_start_time.ToString() + "'," + "'" + mon_lunch_end_time.ToString() + "'," + "'" + tue_lunch_start_time.ToString() + "'," + "'" + tue_lunch_end_time.ToString() + "'," + "'" + wed_lunch_start_time.ToString() + "'," + "'" + wed_lunch_end_time.ToString() + "'," + "'" + thu_lunch_start_time.ToString() + "'," + "'" + thu_lunch_end_time.ToString() + "'," + "'" + fri_lunch_start_time.ToString() + "'," + "'" + fri_lunch_end_time.ToString() + "'," + "'" + sat_lunch_start_time.ToString() + "'," + "'" + sat_lunch_end_time.ToString() + "'," + (last_batch_run == DateTime.MinValue ? "NULL" : "'" + last_batch_run.ToString("yyyy-MM-dd HH:mm:ss") + "'") + ");SELECT SCOPE_IDENTITY();";
return(Convert.ToInt32(DBBase.ExecuteSingleResult(sql)));
}
static void Main(string[] args)
{
using (var entityDB = new EntityDB())
{
entityDB.Products.Add(new Product { Name = "Milk" });
entityDB.SaveChanges();
foreach (var product in entityDB.Products.ToList())
{
Console.WriteLine(product.Name);
}
}
}
public static bool SendMessage(int memberId, string title, string content)
{
EntityDB entity = new EntityDB();
member_message message = new member_message()
{
content = content,
member_id = memberId,
state_read = false,
sys_datetime = DateTime.Now,
title = title,
};
entity.member_message.Add(message);
return(entity.SaveChanges() > 0);
}
static void Main(string[] args)
{
using (var entityDB = new EntityDB())
{
entityDB.Products.Add(new Product {
Name = "Milk"
});
entityDB.SaveChanges();
foreach (var product in entityDB.Products.ToList())
{
Console.WriteLine(product.Name);
}
}
}
public static int Insert(int added_by, int title_id, string firstname, string middlename, string surname, string nickname, string gender, DateTime dob)
{
if (added_by < 0)
{
throw new CustomMessageException("Support staff can not add people to the system. To do this, login as a standard user");
}
int entityID = EntityDB.Insert();
firstname = firstname.Trim().Replace("'", "''");
middlename = middlename.Trim().Replace("'", "''");
surname = surname.Trim().Replace("'", "''");
nickname = nickname.Trim().Replace("'", "''");
gender = gender.Replace("'", "''");
string sql = "INSERT INTO Person (entity_id,added_by,title_id,firstname,middlename,surname,nickname,gender,dob) VALUES (" + entityID.ToString() + "," + added_by + "," + title_id + "," + "'" + firstname + "'," + "'" + middlename + "'," + "'" + surname + "'," + "'" + nickname + "'," + "'" + gender + "'," + (dob == DateTime.MinValue ? "NULL" : "'" + dob.ToString("yyyy-MM-dd HH:mm:ss") + "'") + ");SELECT SCOPE_IDENTITY();";
return(Convert.ToInt32(DBBase.ExecuteSingleResult(sql)));
}
public static int Insert(string name, int site_type_id, string abn, string acn, string tfn, string asic, bool is_provider, string bank_bpay, string bank_bsb, string bank_account, string bank_direct_debit_userid, string bank_username, decimal oustanding_balance_warning, bool print_epc, bool excl_sun, bool excl_mon, bool excl_tue, bool excl_wed, bool excl_thu, bool excl_fri, bool excl_sat, TimeSpan day_start_time, TimeSpan lunch_start_time, TimeSpan lunch_end_time, TimeSpan day_end_time, DateTime fiscal_yr_end, int num_booking_months_to_get)
{
int entityID = EntityDB.Insert();
name = name.Replace("'", "''");
abn = abn.Replace("'", "''");
acn = acn.Replace("'", "''");
tfn = tfn.Replace("'", "''");
asic = asic.Replace("'", "''");
bank_bpay = bank_bpay.Replace("'", "''");
bank_bsb = bank_bsb.Replace("'", "''");
bank_account = bank_account.Replace("'", "''");
bank_direct_debit_userid = bank_direct_debit_userid.Replace("'", "''");
bank_username = bank_username.Replace("'", "''");
string sql = "INSERT INTO Site (entity_id,name,site_type_id,abn,acn,tfn,asic,is_provider,bank_bpay,bank_bsb,bank_account,bank_direct_debit_userid,bank_username,oustanding_balance_warning,print_epc,excl_sun,excl_mon,excl_tue,excl_wed,excl_thu,excl_fri,excl_sat,day_start_time,lunch_start_time,lunch_end_time,day_end_time,fiscal_yr_end,num_booking_months_to_get) VALUES (" + entityID + "" + "'" + name + "'," + site_type_id + ",'" + abn + "'," + "'" + acn + "'," + "'" + tfn + "'," + "'" + asic + "'," + (is_provider ? "1," : "0,") + "'" + bank_bpay + "'," + "'" + bank_bsb + "'," + "'" + bank_account + "'," + "'" + bank_direct_debit_userid + "'," + "'" + bank_username + "'," + "" + oustanding_balance_warning + "," + (print_epc ? "1," : "0,") + (excl_sun ? "1," : "0,") + (excl_mon ? "1," : "0,") + (excl_tue ? "1," : "0,") + (excl_wed ? "1," : "0,") + (excl_thu ? "1," : "0,") + (excl_fri ? "1," : "0,") + (excl_sat ? "1," : "0,") + "'" + day_start_time.ToString() + "'," + "'" + lunch_start_time.ToString() + "'," + "'" + lunch_end_time.ToString() + "'," + "'" + day_end_time.ToString() + "'," + "'" + fiscal_yr_end.ToString("yyyy-MM-dd HH:mm:ss") + "'," + "" + num_booking_months_to_get + "" + ");SELECT SCOPE_IDENTITY();";
return(Convert.ToInt32(DBBase.ExecuteSingleResult(sql)));
}
public override async Task OnActivateAsync()
{
Identity = this.GetPrimaryKeyLong();
_Logger = ServiceProvider.GetService <ILoggerFactory>().CreateLogger("Node[" + Identity + "]");
_CacheClient = ServiceProvider.GetService <IRedisCacheClient>();
_IMongoClient = ServiceProvider.GetService <IMongoClient>();
EntityDB = ServiceProvider.GetService <IEntityDB>();
IdGenerator = ServiceProvider.GetService <IIdGeneratorService>();
EntityManager = new EntityManager();
TimerManager = new TimerManager(this);
NodeType = await EntityDB.GetNodeType(Identity);
BatchCahceList = new List <NList>();
RegisterTimer(ScheduledSave, null, TimeSpan.FromSeconds(0), TimeSpan.FromMilliseconds(TimeUtils.MINITE));
bool persist = await EntityDB.IsPersist(Identity);
if (persist)
{
IReadOnlyList <Entity> entities = await LoadPersistEntities();
if (NodeType == NodeType.Grain)
{
foreach (Entity entity in entities)
{
await Load(entity);
}
}
else if (NodeType == NodeType.Cache)
{
if (!await CacheExist(Nuid.New(Identity, Identity)))
{
await SetCacheEntities(entities);
}
}
}
await base.OnActivateAsync();
}
public override async Task OnActivateAsync()
{
await base.OnActivateAsync();
_SystemListener = new Dictionary <int, Func <NList, Task> >();
_Logger = ServiceProvider.GetService <ILoggerFactory>().CreateLogger("RoleAgent[" + Role + "]");
Role = this.GetPrimaryKeyLong();
_RoleNode = GrainFactory.GetGrain <INode>(Role);
_RoleId = Nuid.New(Role, Role);
if (!await EntityDB.IsPersist(Role))
{
await EntityDB.SetNodeType(Role, NodeType.Grain);
await _RoleNode.Create(_RoleId, Player.TYPE, NList.New());
}
await _RoleNode.BindAgent(this);
RegisterSystem(SystemMsg.CLIENT.CUSTOM, OnRecv_Custom);
}
private static List <ImmobiliModel> GetImmobiliList()
{
using (var session = DatabaseUtilities.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
try
{
EntityDB <ImmobiliModel> entityDb = new EntityDB <ImmobiliModel>();
string query = "SELECT * FROM Immobili";
SqlCommand command = new SqlCommand(query, session, transaction);
SqlDataReader executeSqlDataReader = command.ExecuteReader();
List <ImmobiliModel> immobili = new List <ImmobiliModel>();
while (executeSqlDataReader.Read())
{
var immobile = new ImmobiliModel()
{
Id = long.Parse(executeSqlDataReader["Id"].ToString()),
TipoImmobile = executeSqlDataReader["TipoImmobile"].ToString(),
Descrizione = executeSqlDataReader["Descrizione"].ToString(),
Mq = executeSqlDataReader["Mq"].ToString(),
Nome = executeSqlDataReader["Nome"].ToString(),
Posizione = executeSqlDataReader["Posizione"].ToString(),
Prezzo = executeSqlDataReader["Prezzo"].ToString()
};
immobili.Add(immobile);
}
executeSqlDataReader.Close();
return(immobili);
}
catch (Exception ex)
{
transaction.Rollback();
throw ex;
}
}
}
}
public ActionResult RicercaImmobili(FormCollection form)
{
string tipoImmobile = form["TipoImmobile"].ToString();
string posizione = form["Posizione"].ToString();
string mq = form["Mq"].ToString();
using (var session = DatabaseUtilities.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
try
{
EntityDB <RicercaImmobiliModel> entityDb = new EntityDB <RicercaImmobiliModel>();
string query = "SELECT * FROM Immobili " +
" WHERE 1=1";
if (!string.IsNullOrEmpty(tipoImmobile))
{
query = query + " AND TipoImmobile=@tipoImmobile";
}
if (!string.IsNullOrEmpty(mq))
{
query = query + " AND Mq=@mq";
}
if (!string.IsNullOrEmpty(posizione))
{
query = query + " AND Posizione=@posizione";
}
SqlCommand command = new SqlCommand(query, session, transaction);
if (!string.IsNullOrEmpty(tipoImmobile))
{
command.Parameters.AddWithValue("@tipoImmobile", tipoImmobile);
}
if (!string.IsNullOrEmpty(mq))
{
command.Parameters.AddWithValue("@mq", mq);
}
if (!string.IsNullOrEmpty(posizione))
{
command.Parameters.AddWithValue("@posizione", posizione);
}
SqlDataReader executeSqlDataReader = command.ExecuteReader();
List <RicercaImmobiliModel> immobili = new List <RicercaImmobiliModel>();
while (executeSqlDataReader.Read())
{
var immobile = new RicercaImmobiliModel()
{
Id = long.Parse(executeSqlDataReader["Id"].ToString()),
TipoImmobile = executeSqlDataReader["TipoImmobile"].ToString(),
Descrizione = executeSqlDataReader["Descrizione"].ToString(),
Mq = executeSqlDataReader["Mq"].ToString(),
Nome = executeSqlDataReader["Nome"].ToString(),
Posizione = executeSqlDataReader["Posizione"].ToString(),
Prezzo = executeSqlDataReader["Prezzo"].ToString()
};
immobili.Add(immobile);
}
//entityDb.DataReaderMapList<RicercaImmobiliModel>(executeSqlDataReader);
executeSqlDataReader.Close();
return(View(immobili));
}
catch (Exception ex)
{
transaction.Rollback();
return(View(new List <RicercaImmobiliModel>()));
}
}
}
}
private bool IsValidFormScreen()
{
string screen = Request.QueryString["screen"];
return(screen != null && Regex.IsMatch(screen, @"^\d+$") && EntityDB.IDExists(Convert.ToInt32(Request.QueryString["screen"])));
}
private bool IsValidFormID()
{
string id = Request.QueryString["id"];
return(id != null && Regex.IsMatch(id, @"^\d+$") && EntityDB.IDExists(Convert.ToInt32(Request.QueryString["id"])));
}
public ActionResult AggiungiFoto(IEnumerable <HttpPostedFileBase> file, string id)
{
string filepath = "~/Images/";
var path = Server.MapPath(filepath + id);
DirectoryInfo d = new DirectoryInfo(path);
if (!d.Exists)
{
d.Create();
}
int i = 0;
foreach (var f in file)
{
if (file != null)
{
string pic = System.IO.Path.GetFileName(f.FileName);
string imgPath = System.IO.Path.Combine(path, pic);
f.SaveAs(imgPath);
}
}
using (var session = DatabaseUtilities.OpenSession())
{
using (var transaction = session.BeginTransaction())
{
try
{
EntityDB <ImmobiliModel> entityDb = new EntityDB <ImmobiliModel>();
string query = "SELECT * FROM Immobili " +
" WHERE id=@id";
SqlCommand command = new SqlCommand(query, session, transaction);
command.Parameters.AddWithValue("@id", id);
SqlDataReader executeSqlDataReader = command.ExecuteReader();
ImmobiliModel immobili = entityDb.DataReaderMapToList <ImmobiliModel>(executeSqlDataReader);
executeSqlDataReader.Close();
if (immobili != null)
{
List <PictureModel> pic = new List <PictureModel>();
if (d.Exists)
{
foreach (var f in d.GetFiles())
{
pic.Add(new PictureModel()
{
name = f.Name,
image = System.IO.File.ReadAllBytes(f.FullName)
});
}
immobili.Picture = pic;
}
return(PartialView("RiepilogoImmobile", immobili));
}
return(PartialView("RiepilogoImmobile", new ImmobiliModel()));
}
catch (Exception ex)
{
transaction.Rollback();
ModelState.AddModelError(string.Empty, "Server error try after some time.");
return(PartialView("RiepilogoImmobile", new ImmobiliModel()));
}
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (GetUrlParamType() == UrlParamType.View)
{
maintable.Visible = false; // hide this so that we don't send all the page data (all suburbs, etc) to display before it redirects
Response.Redirect(UrlParamModifier.AddEdit(Request.RawUrl, "type", "edit"));
}
else if (GetUrlParamType() == UrlParamType.Edit)
{
if (!IsValidFormID())
{
HideTableAndSetErrorMessage();
return;
}
ContactAus contact = ContactAusDB.GetByID(GetFormID());
if (contact == null)
{
HideTableAndSetErrorMessage("Invalid contact ID");
return;
}
bool isAddress = contact.ContactType.ContactTypeGroup.ID == 1;
bool isTelecoms = contact.ContactType.ContactTypeGroup.ID == 2;
bool isBedroom = contact.ContactType.ContactTypeGroup.ID == 3;
bool isWeb = contact.ContactType.ContactTypeGroup.ID == 4;
bool isMobile = Convert.ToInt32(ddlContactType.SelectedValue) == 30;
bool isPOBox = Convert.ToInt32(ddlContactType.SelectedValue) == 37 || Convert.ToInt32(ddlContactType.SelectedValue) == 262;
bool isEmail = Convert.ToInt32(ddlContactType.SelectedValue) == 27;
bool isWebsite = Convert.ToInt32(ddlContactType.SelectedValue) == 28;
txtAddrLine1.Text = txtAddrLine1.Text.Trim();
if (isMobile && !System.Text.RegularExpressions.Regex.Replace(txtAddrLine1.Text, "[^0-9]", "").StartsWith("0"))
{
SetErrorMessage("Mobile number must start with 0");
return;
}
if (isTelecoms && System.Text.RegularExpressions.Regex.Replace(txtAddrLine1.Text, "[^0-9]", "").Length > 13)
{
SetErrorMessage("Phone number can not be more than 13 digits");
return;
}
if (isEmail && !Utilities.IsValidEmailAddress(txtAddrLine1.Text))
{
SetErrorMessage("Invalid email address");
return;
}
if (isWebsite && !Utilities.IsValidWebURL(txtAddrLine1.Text))
{
SetErrorMessage("Invalid website");
return;
}
if (isPOBox && !Regex.IsMatch(txtAddrLine1.Text, "PO Box", RegexOptions.IgnoreCase) && !Regex.IsMatch(txtAddrLine2.Text, "PO Box", RegexOptions.IgnoreCase))
{
SetErrorMessage("The address text must contain \"PO Box\"");
return;
}
ContactAusDB.Update(Convert.ToInt32(lblId.Text),
Convert.ToInt32(ddlContactType.SelectedValue),
txtFreeText.Text,
isTelecoms ? System.Text.RegularExpressions.Regex.Replace(txtAddrLine1.Text, "[^0-9]", "") : txtAddrLine1.Text,
txtAddrLine2.Text,
txtStreet.Text,
isAddress ? Convert.ToInt32(ddlAddressChannelType.SelectedValue) : (contact.AddressChannelType == null ? -1 : contact.AddressChannelType.ID),
//isAddress ? Convert.ToInt32(ddlSuburb.SelectedValue) : (contact.Suburb == null ? -1 : contact.Suburb.SuburbID),
isAddress ? Convert.ToInt32(suburbID.Value) : (contact.Suburb == null ? -1 : contact.Suburb.SuburbID),
isAddress ? Convert.ToInt32(ddlCountry.SelectedValue) : (contact.Country == null ? -1 : contact.Country.ID),
contact.Site == null ? Convert.ToInt32(Session["SiteID"]) : contact.Site.SiteID,
isAddress || isWeb ? chkIsBilling.Checked : contact.IsBilling,
isAddress || isWeb ? chkIsNonBilling.Checked : contact.IsNonBilling);
//close this window
maintable.Visible = false; // hide this so that we don't send all the page data (all suburbs, etc) to display before it closes
bool refresh_on_close = Request.QueryString["refresh_on_close"] != null && Request.QueryString["refresh_on_close"] == "1";
if (refresh_on_close)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script language=javascript>window.opener.location.href=window.opener.location.href;self.close();</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script language=javascript>window.returnValue=false;self.close();</script>");
}
}
else if (GetUrlParamType() == UrlParamType.Add)
{
if (!IsValidFormID())
{
HideTableAndSetErrorMessage();
return;
}
int entityID = GetFormID();
if (!EntityDB.IDExists(entityID))
{
HideTableAndSetErrorMessage("Invalid entity ID");
return;
}
int contactTypeGroupID = -1;
UrlParamContactTypeGroup urlParamContactTypeGroup = GetUrlParamContactTypeGroup();
if (urlParamContactTypeGroup == UrlParamContactTypeGroup.Mailing)
{
contactTypeGroupID = 1;
}
else if (urlParamContactTypeGroup == UrlParamContactTypeGroup.Telecoms)
{
contactTypeGroupID = 2;
}
else if (urlParamContactTypeGroup == UrlParamContactTypeGroup.Bedroom)
{
contactTypeGroupID = 3;
}
else if (urlParamContactTypeGroup == UrlParamContactTypeGroup.Internet)
{
contactTypeGroupID = 4;
}
else
{
HideTableAndSetErrorMessage("Invalid contact_group_type ID");
return;
}
bool isAddress = contactTypeGroupID == 1;
bool isTelecoms = contactTypeGroupID == 2;
bool isBedroom = contactTypeGroupID == 3;
bool isWeb = contactTypeGroupID == 4;
bool isMobile = Convert.ToInt32(ddlContactType.SelectedValue) == 30;
bool isPOBox = Convert.ToInt32(ddlContactType.SelectedValue) == 37 || Convert.ToInt32(ddlContactType.SelectedValue) == 262;
bool isEmail = Convert.ToInt32(ddlContactType.SelectedValue) == 27;
bool isWebsite = Convert.ToInt32(ddlContactType.SelectedValue) == 28;
txtAddrLine1.Text = txtAddrLine1.Text.Trim();
if (isMobile && !System.Text.RegularExpressions.Regex.Replace(txtAddrLine1.Text, "[^0-9]", "").StartsWith("0"))
{
SetErrorMessage("Mobile number must start with 0");
return;
}
if (isTelecoms && System.Text.RegularExpressions.Regex.Replace(txtAddrLine1.Text, "[^0-9]", "").Length > 13)
{
SetErrorMessage("Phone number can not be more than 13 digits");
return;
}
if (isEmail && !Utilities.IsValidEmailAddress(txtAddrLine1.Text))
{
SetErrorMessage("Invalid email address");
return;
}
if (isWebsite && !Utilities.IsValidWebURL(txtAddrLine1.Text))
{
SetErrorMessage("Invalid website");
return;
}
if (isPOBox && !Regex.IsMatch(txtAddrLine1.Text, "PO Box", RegexOptions.IgnoreCase) && !Regex.IsMatch(txtAddrLine2.Text, "PO Box", RegexOptions.IgnoreCase))
{
SetErrorMessage("The address text must contain \"PO Box\"");
return;
}
int contactID = ContactAusDB.Insert(entityID,
Convert.ToInt32(ddlContactType.SelectedValue),
txtFreeText.Text,
isTelecoms ? System.Text.RegularExpressions.Regex.Replace(txtAddrLine1.Text, "[^0-9]", "") : txtAddrLine1.Text,
txtAddrLine2.Text,
txtStreet.Text,
isAddress ? Convert.ToInt32(ddlAddressChannelType.SelectedValue) : -1,
//isAddress ? Convert.ToInt32(ddlSuburb.SelectedValue) : -1,
isAddress ? Convert.ToInt32(suburbID.Value) : -1,
isAddress ? Convert.ToInt32(ddlCountry.SelectedValue) : -1,
Convert.ToInt32(Session["SiteID"]),
isAddress || isWeb ? chkIsBilling.Checked : true,
isAddress || isWeb ? chkIsNonBilling.Checked : true);
// close this window
maintable.Visible = false; // hide this so that we don't send all the page data (all suburbs, etc) to display before it closes
bool refresh_on_close = Request.QueryString["refresh_on_close"] != null && Request.QueryString["refresh_on_close"] == "1";
if (refresh_on_close)
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script language=javascript>window.opener.location.href=window.opener.location.href;self.close();</script>");
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script language=javascript>window.returnValue=false;self.close();</script>");
}
}
else
{
HideTableAndSetErrorMessage("", "Invalid URL Parameters");
}
}
public UserDAO()
{
db = new EntityDB();
}
