private static void LoadCatagoryModels()
{
if (Managers.Data.FileData.CatagoryModels.Count == 0)
{
CatagoryModel Catagory1 = new CatagoryModel();
Catagory1.ColorCode = "e06c75";
Catagory1.NameText = "Roth IRA";
Catagory1.Recurring = true;
Catagory1.Save();
CatagoryModel Catagory2 = new CatagoryModel();
Catagory2.ColorCode = "61afef";
Catagory2.NameText = "Restaurant";
Catagory2.Recurring = false;
Catagory2.Save();
CatagoryModel Catagory3 = new CatagoryModel();
Catagory3.ColorCode = "ffb86c";
Catagory3.NameText = "Mortgage";
Catagory3.Recurring = true;
Catagory3.Save();
CatagoryModel Catagory4 = new CatagoryModel();
Catagory4.ColorCode = "acce1b";
Catagory4.NameText = "Miscellaneous";
Catagory4.Recurring = false;
Catagory4.Save();
CatagoryModel Catagory5 = new CatagoryModel();
Catagory5.ColorCode = "c678dd";
Catagory5.NameText = "HOA";
Catagory5.Recurring = true;
Catagory5.Save();
CatagoryModel Catagory6 = new CatagoryModel();
Catagory6.ColorCode = "94B57C";
Catagory6.NameText = "Groceries";
Catagory6.Recurring = false;
Catagory6.Save();
CatagoryModel Catagory7 = new CatagoryModel();
Catagory7.ColorCode = "d19a66";
Catagory7.NameText = "Gas";
Catagory7.Recurring = false;
Catagory7.Save();
CatagoryModel Catagory8 = new CatagoryModel();
Catagory8.ColorCode = "60B9BD";
Catagory8.NameText = "Entertainment";
Catagory8.Recurring = false;
Catagory8.Save();
CatagoryModel Catagory9 = new CatagoryModel();
Catagory9.ColorCode = "FF79C6";
Catagory9.NameText = "Extra Mortgage";
Catagory9.Recurring = true;
Catagory9.Save();
}
}
private void catagorySaveButton_Click(object sender, EventArgs e)
{
if (!Ch.IsMatch(catagoryTextBox.Text.Trim()))
{
cMessageBox.Warning("Invaild Input Detected");
}
else
{
CatagoryModel catagoryModel = new CatagoryModel();
catagoryModel.Name = catagoryTextBox.Text.Trim();
SetupGateway catagoryGateway = new SetupGateway();
bool isExist = catagoryGateway.IsExists(catagoryModel);
if (isExist == true)
{
cMessageBox.Information("Category Already Exist");
}
else
{
int rowAffect = catagoryGateway.SaveCatagory(catagoryModel);
if (rowAffect > 0)
{
cMessageBox.Success("Category Successfully Saved");
CatagorySetup_Load(sender, e);
}
else
{
cMessageBox.Failed("Failed To Save Category, Try Again");
CatagorySetup_Load(sender, e);
}
}
}
}
public void UpdateView(CatagoryModel model, decimal catagoryTotal)
{
NameTextMesh.text = model.NameText;
SetColor(model.ColorCode);
TotalTextMesh.text = "$" + catagoryTotal.ToString();
SetAction(Controller.Instance.PushCatagoryWindow, model.CatagoryID);
}
private void CatagoryUpdateButton_Click(object sender, EventArgs e)
{
SetupGateway setupGateway = new SetupGateway();
if (idhiddenLabel.Text.Trim() != String.Empty && Ch.IsMatch(catagoryTextBox.Text.Trim()))
{
CatagoryModel catagory = new CatagoryModel();
catagory.Name = catagoryTextBox.Text.Trim();
catagory.Id = Convert.ToInt32(idhiddenLabel.Text);
bool isExist = setupGateway.IsExists(catagory);
if (isExist == true)
{
cMessageBox.Information("Category Already Exist");
}
else
{
int rowAffect = setupGateway.UpdateCatagory(catagory);
if (rowAffect > 0)
{
cMessageBox.Success("Category Updated");
CatagorySetup_Load(sender, e);
}
else
{
cMessageBox.Failed("Faild to Updated Category");
CatagorySetup_Load(sender, e);
}
}
}
}
private CatagoryElement ConstructCatagoryElement(CatagoryModel model, decimal total, int index)
{
CatagoryElement newExpense = GameObject.Instantiate(original: CatagoryElements[index - 1], parent: CatagoryElements[index - 1].transform.parent.transform) as CatagoryElement;
RectTransform newRect = newExpense.GetComponent <RectTransform>();
newRect.anchoredPosition = new Vector3(newRect.anchoredPosition.x, newRect.anchoredPosition.y - CatagoryOffset);
//newExpense.SetTileRect(TileRect); Add Later if I want the catagory tiles to scroll.
newExpense.UpdateView(model, total);
return(newExpense);
}
private void Page_Loaded(object sender, RoutedEventArgs e)
{
catagory = (CatagoryModel)this.FindResource("cat");
POS_Catagory();
fly.DataContext = _itemViewModel;
flyout.DataContext = newcatagory;
webHandler.POS_add_catagoryCompleted += async(x, y) =>
{
if (y.Result == 1)
{
var win = (MetroWindow)Application.Current.MainWindow;
var res = await win.ShowMessageAsync("New catagory added", "new catagory was succefully added",
MessageDialogStyle.Affirmative);
}
else
{
var win = (MetroWindow)Application.Current.MainWindow;
var res = await win.ShowMessageAsync("Something went wrong", "try again in a little bit",
MessageDialogStyle.Affirmative);
}
};
webHandler.POS_update_catagoryCompleted += async(x, y) =>
{
if (y.Result == 1)
{
var win = (MetroWindow)Application.Current.MainWindow;
var res = await win.ShowMessageAsync("Catagory changes saved", "",
MessageDialogStyle.Affirmative);
}
else
{
var win = (MetroWindow)Application.Current.MainWindow;
var res = await win.ShowMessageAsync("Something went wrong", "try again in a little bit",
MessageDialogStyle.Affirmative);
}
};
webHandler.POS_delete_catagoryCompleted += async(x, y) =>
{
if (y.Result == 1)
{
var win = (MetroWindow)Application.Current.MainWindow;
var res = await win.ShowMessageAsync("Catgory removed", "The Catgory was removed",
MessageDialogStyle.Affirmative);
}
else
{
var win = (MetroWindow)Application.Current.MainWindow;
var res = await win.ShowMessageAsync("Something went wrong", "try again in a little bit",
MessageDialogStyle.Affirmative);
}
};
}
public bool IsExists(CatagoryModel catagory)
{
string query = "SELECT * FROM Catagories WHERE Name=@catagory";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@catagory", catagory.Name);
Connection.Open();
Reader = Command.ExecuteReader();
bool isExists = Reader.HasRows;
Connection.Close();
return(isExists);
}
public int Update(CatagoryModel catagoryRelator)
{
string query = "Update catagoris SET catagory = @catagory WHERE Id = @id";
command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@catagory", catagoryRelator.Catagory);
command.Parameters.AddWithValue("@Id", catagoryRelator.Id);
connection.Open();
int rowAffect = command.ExecuteNonQuery();
connection.Close();
return(rowAffect);
}
private CatagoryModel[] GetFilteredCatagoryModels(List <CatagoryModel> catagoryModels)
{
CatagoryModel[] newCatagoryModels = new CatagoryModel[MatchedIsRecurringCount(catagoryModels)];
int count = 0;
for (int index = 0; index < catagoryModels.Count; index++)
{
if (catagoryModels[index].Recurring == IsRecurring)
{
newCatagoryModels[count++] = catagoryModels[index];
}
}
return(newCatagoryModels);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
int Id = Convert.ToInt32(Request.QueryString["Id"]);
//Response.Write(Id);
CatagoryModel catagoryRelator = catagoryManager.GetCatagoryByID(Id);
if (catagoryRelator != null)
{
hiddenFieldID.Value = Convert.ToString(catagoryRelator.Id);
catagotyTextBox.Text = catagoryRelator.Catagory;
hiddenFieldID.Value = catagoryRelator.Id.ToString();
}
}
}
public void Save()
{
if (CatagoryID == -1)
{
CatagoryID = IDTracker.CreateNew(IDType.CATAGORY);
IDTracker.SaveID(IDType.CATAGORY, CatagoryID);
}
else
{
CatagoryModel modelToDelete = UI.DataQueries.GetCatagoryModel(Managers.Data.FileData.CatagoryModels, CatagoryID);
Managers.Data.FileData.CatagoryModels.Remove(modelToDelete);
}
Managers.Data.FileData.CatagoryModels.Add(this);
Managers.Data.Save();
//Messenger.Broadcast(AppEvent.CATAGORIES_UPDATED);
}
public int save(CatagoryModel catagoryRelator)
{
string query = "Insert Into catagoris(catagory) values(@catagory)";
command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@catagory", catagoryRelator.Catagory);
connection.Open();
int rowAffect = command.ExecuteNonQuery();
connection.Close();
return(rowAffect);
}
public int SaveCatagory(CatagoryModel catagory)
{
try
{
Connection.Open();
string query = "Insert Into Catagories(Name) values(@name)";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@name", catagory.Name);
int rowAffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffect);
}
catch (Exception)
{
return(0);
}
}
protected void catagroySavebutton_Click(object sender, EventArgs e)
{
if (catagotyTextBox.Text.Trim() == "")
{
outputlabel.InnerHtml = "Please Provide a vailed Catagory";
}
else
{
CatagoryModel catagoryRelator = new CatagoryModel();
catagoryRelator.Catagory = catagotyTextBox.Text;
string message = CatagoryManager.catagorySave(catagoryRelator);
outputlabel.InnerHtml = message;
CatagoryListGridVew.DataSource = CatagoryManager.GetAllCatagory();
CatagoryListGridVew.DataBind();
}
}
public int UpdateCatagory(CatagoryModel catagoryModel)
{
try
{
string query = "Update Catagories SET Name = @name WHERE Id= @id";
Command = new SqlCommand(query, Connection);
Command.Parameters.AddWithValue("@name", catagoryModel.Name);
Command.Parameters.AddWithValue("@id", catagoryModel.Id);
Connection.Open();
int rowAffect = Command.ExecuteNonQuery();
Connection.Close();
return(rowAffect);
}
catch (Exception)
{
return(0);
}
}
public string catagoryUpdate(CatagoryModel catagoryRelator)
{
if (catagoryGateway.IsExists(catagoryRelator.Catagory))
{
return("* Catagroy Name Alredy Exist Try Different Name");
}
else
{
int rowAffect = catagoryGateway.Update(catagoryRelator);
if (rowAffect > 0)
{
return("Catagory Update Seccesfull");
}
else
{
return("*Catagory Does Not Updated");
}
}
}
public string catagorySave(CatagoryModel catagoryRelator)
{
if (catagoryGateway.IsExists(catagoryRelator.Catagory))
{
return("* Catagroy Name Alredy Exist");
}
else
{
int rowAffect = catagoryGateway.save(catagoryRelator);
if (rowAffect > 0)
{
return("Catagory setup Seccesfull");
}
else
{
return("*Data Not Saved Try Again");
}
}
}
protected void catagroyUpdateButton_Click(object sender, EventArgs e)
{
if (catagotyTextBox.Text.Trim() == "")
{
outputlabel.InnerHtml = "Please Provide a vailed Catagory";
}
else
{
CatagoryModel catagoryRelator = new CatagoryModel();
catagoryRelator.Id = Convert.ToInt32(hiddenFieldID.Value);
catagoryRelator.Catagory = catagotyTextBox.Text;
string message = catagoryManager.catagoryUpdate(catagoryRelator);
outputlabel.InnerHtml = message;
if (outputlabel.InnerHtml.Contains("Catagory Update Seccesfull"))
{
Response.Redirect("CatagoryUI.aspx");
}
}
}
public List <CatagoryModel> GetAllCatagory()
{
List <CatagoryModel> catagoryList = new List <CatagoryModel>();
String query = "SELECT*FROM Catagories WHERE Active =1";
Command = new SqlCommand(query, Connection);
Connection.Open();
Reader = Command.ExecuteReader();
while (Reader.Read())
{
CatagoryModel catagroy = new CatagoryModel();
catagroy.Id = Convert.ToInt32(Reader["Id"]);
catagroy.Name = Reader["Name"].ToString();
catagoryList.Add(catagroy);
}
Reader.Close();
Connection.Close();
return(catagoryList);
}
public List <CatagoryModel> GetAllCatagory()
{
List <CatagoryModel> catagoryList = new List <CatagoryModel>();
String query = "SELECT*FROM Catagoris";
command = new SqlCommand(query, connection);
connection.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
CatagoryModel CatagoryRelator = new CatagoryModel();
CatagoryRelator.Id = Convert.ToInt32(reader["Id"]);
CatagoryRelator.Catagory = reader["Catagory"].ToString();
catagoryList.Add(CatagoryRelator);
}
reader.Close();
connection.Close();
return(catagoryList);
}
private async void catagorytList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
try
{
selected = (CatagoryModel)catagoryList.SelectedItem;
if (selected != null)
{
del.IsEnabled = true;
}
}
catch (Exception)
{
del.IsEnabled = false;
update.Foreground = Brushes.Gray;
del.Foreground = Brushes.Gray;
var win = (MetroWindow)Application.Current.MainWindow;
var res = await win.ShowMessageAsync("Something went wrong", "Try again in a little bit",
MessageDialogStyle.AffirmativeAndNegative);
}
}
public HttpResponseMessage CatagoryAdd(CatagoryModel _CatagoryModel)
{
try
{
bool conn = false;
conn = db.Database.Exists();
if (!conn)
{
ConnectionTools.changeToLocalDB(db);
conn = db.Database.Exists();
}
if (conn)
{
TBL_CATAGORY cat = new TBL_CATAGORY();
cat.BAR_CODE_PREFIX = _CatagoryModel.BAR_CODE_PREFIX;
cat.CATAGORY_DEC = _CatagoryModel.CATAGORY_DEC;
cat.CATAGORY_NAME = _CatagoryModel.CATAGORY_NAME;
cat.COMPANY_ID = _CatagoryModel.COMPANY_ID;
cat.DISPLAY_INDEX = _CatagoryModel.DISPLAY_INDEX;
cat.IS_DELETE = false;
cat.IS_NOT_PROTAL = _CatagoryModel.IS_NOT_PROTAL;
db.TBL_CATAGORY.Add(cat);
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "success"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
catch (Exception ex)
{
throw;
}
finally
{
ConnectionTools.ChangeToRemoteDB(db);
}
}
public HttpResponseMessage CatagoryUpdate(CatagoryModel _CatagoryModel)
{
try
{
bool conn = false;
conn = db.Database.Exists();
if (!conn)
{
ConnectionTools.changeToLocalDB(db);
conn = db.Database.Exists();
}
if (conn)
{
var str = (from a in db.TBL_CATAGORY where a.CATAGORY_ID == _CatagoryModel.CATAGORY_ID select a).FirstOrDefault();
str.BAR_CODE_PREFIX = _CatagoryModel.BAR_CODE_PREFIX;
str.CATAGORY_DEC = _CatagoryModel.CATAGORY_DEC;
str.CATAGORY_NAME = _CatagoryModel.CATAGORY_NAME;
str.COMPANY_ID = _CatagoryModel.COMPANY_ID;
str.DISPLAY_INDEX = _CatagoryModel.DISPLAY_INDEX;
str.IS_DELETE = false;
str.IS_NOT_PROTAL = _CatagoryModel.IS_NOT_PROTAL;
db.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK, "success"));
}
else
{
return(Request.CreateResponse(HttpStatusCode.ExpectationFailed));
}
}
catch (Exception ex)
{
throw;
}
finally
{
ConnectionTools.ChangeToRemoteDB(db);
}
}
public CatagoryModel GetCatagoryByID(int Id)
{
String query = "SELECT*FROM Catagoris WHERE Id = @Id";
command = new SqlCommand(query, connection);
command.Parameters.AddWithValue("@Id", Id);
connection.Open();
reader = command.ExecuteReader();
reader.Read();
CatagoryModel CatagoryRelator = null;
if (reader.HasRows)
{
CatagoryRelator = new CatagoryModel();
CatagoryRelator.Id = Convert.ToInt32(reader["Id"]);
CatagoryRelator.Catagory = reader["Catagory"].ToString();
}
reader.Close();
connection.Close();
return(CatagoryRelator);
}
public void UpdateView(CatagoryModel Model, float width)
{
BarRect.sizeDelta = new Vector2(width, BarRect.sizeDelta.y);
ColorBarImage.color = ColorConverter.HexToColor(Model.ColorCode);
}
