public static bool SendDailyInventoryStatus(int branchID, DateTime dateFrom, DateTime toFrom)
{
try {
DateTime from = new DateTime(dateFrom.Year, dateFrom.Month, dateFrom.Day, 0, 0, 0);
DateTime to = new DateTime(toFrom.Year, toFrom.Month, toFrom.Day, 23, 59, 59);
var db = ModuleClass.GetConnection();
var list = db.vw_ReorderItem.Where(s => s.Date > from && s.Date < to && s.BranchID == branchID && s.CurrentQuanity <= s.ReorderPoint && s.CategoryID != 2013).ToList();
if (list.Count() == 0)
{
return(true);
}
string message = " ---- ملخص كميات الأصناف رضا" + branchID + " -----" + Environment.NewLine;
foreach (var item in list)
{
message += item.Name + " " + item.CurrentQuanity + Environment.NewLine;
}
int codeId = (int)PushOverMessageType.DailyInventoryStatus;
var receivers = GetReceiver(codeId);
var title = GetTitle(codeId);
return(SendPushMessage(message, receivers, title));
}
catch (Exception ex)
{
return(false);
}
}
public Login()
{
try
{
InitializeComponent();
//string connString = ModuleClass.Connect();
//DataAccess.RedaV1Entities db = ModuleClass.GetConnection();//= new DataAccess.RedaV1Entities(ModuleClass.Connect());
db = ModuleClass.GetConnection();
DevExpress.UserSkins.BonusSkins.Register();
Assembly executingAssembly = Assembly.GetExecutingAssembly();
AssemblyTitleAttribute assembly = executingAssembly.GetCustomAttribute <AssemblyTitleAttribute>();
AssemblyFileVersionAttribute assemblyVersion = executingAssembly.GetCustomAttribute <AssemblyFileVersionAttribute>();
this.Text = assembly.Title + " " + assemblyVersion.Version;// +" ( " + UserData.Default.UserName + " ) ";// +branch.BranchName;
SkinContainerCollection skins = SkinManager.Default.Skins;
for (int i = 0; i < skins.Count; i++)
{
cmbTheme.Properties.Items.Add(skins[i].SkinName);
}
LoadData();
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
}
}
public static bool SendItemWithoutBarcode(int branchID, DateTime dateFrom, DateTime toFrom)
{
try
{
DateTime from = new DateTime(dateFrom.Year, dateFrom.Month, dateFrom.Day, 0, 0, 0);
DateTime to = new DateTime(toFrom.Year, toFrom.Month, toFrom.Day, 23, 59, 59);
var db = ModuleClass.GetConnection();
var list = db.vw_ReorderItem.Where(s => s.Date > from && s.Date < to && s.BranchID == branchID && s.Remarks != null && s.CategoryID != 2013).ToList();
if (list.Count() == 0)
{
return(true);
}
string message = " ملخص الأصناف بدون باركود رضا" + branchID + " " + Environment.NewLine;
foreach (var item in list)
{
message += item.Name + " " + item.Remarks + " " + item.UserName + Environment.NewLine;
}
int codeId = (int)PushOverMessageType.ItemWithoutBarcode;
var receivers = GetReceiver(codeId);
var title = GetTitle(codeId);
return(SendPushMessage(message, receivers, title));
}
catch (Exception ex)
{
return(false);
}
//return PushMessage.SendPushMessage(message, title);
}
private void btnShowFullReport_Click(object sender, EventArgs e)
{
try
{
DataAccess.RedaV1Entities db = ModuleClass.GetConnection();//= new DataAccess.RedaV1Entities(ModuleClass.Connect());
int invoiceID = 123;
var currentRow = db.vw_SaleReport.Where(s => s.ID == invoiceID).SingleOrDefault(); //(DataAccess.vw_SaleReport)gridViewSaleInvoice.GetFocusedRow();
SaleAllRpt rpt = new SaleAllRpt(Convert.ToDecimal(currentRow.Discount), Convert.ToDecimal(currentRow.Total), currentRow.ID.ToString(), currentRow.UserName.ToString());
var list = from s in db.vw_Sale2 where s.SaleInvoiceID == invoiceID select s;
rpt.DataSource = list.ToList();
try
{
// string InvoicePrinter = System.Configuration.ConfigurationManager.AppSettings["InvoicePrinter"];
ReportPrintTool tool = new ReportPrintTool(rpt);
tool.ShowPreview();
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
}
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
}
}
static List <string> GetReceiver(int CodeID)
{
List <string> receivers;
var db = ModuleClass.GetConnection();
receivers = db.vw_PushoverMessage.Local.Where(s => s.CodeID == CodeID && s.EnableMessage == true && s.PushoverID != null).Select(s => s.PushoverID).ToList();
return(receivers);
}
bool SendWhatsAppMessage(String receiver, String Message)
{
bool result = false;
try
{
//Send ( button_click )
DataAccess.RedaV1Entities db = ModuleClass.GetConnection();//= new DataAccess.RedaV1Entities(ModuleClass.Connect());
DataAccess.Company company = db.Companies.Take(1).SingleOrDefault();
string WhatsAppCode = company.WhatsAppCode; // UserData.Default.WhatsAppCode;
string WhatsAppSender = company.WhatsAppSender; // UserData.Default.WhatsAppSender;
string from = WhatsAppSender;
string to = receiver;
string msg = Message;
WhatsApp wa = new WhatsApp(from, WhatsAppCode, "RedaPos", false, true);
wa.OnConnectSuccess += () =>
{
// MessageBox.Show("Connected to whatsapp...");
wa.OnLoginSuccess += (phoneNumber, data) =>
{
wa.SendMessage(to, msg);
result = true;
};
wa.OnLoginFailed += (data) =>
{
MessageBox.Show("Login Failed : {0}", data);
result = false;
};
wa.Login();
};
wa.OnConnectFailed += (ex) =>
{
MessageBox.Show("Connection Failed...");
result = false;
};
wa.Connect();
}
catch (Exception ex2)
{
result = false;
}
return(result);
}
private void btnAddUser_Click(object sender, EventArgs e)
{
try
{
if (!dxErrorProvider1.HasErrors)
{
int userId = Convert.ToInt32(cmbUserName.EditValue);
int year = DateTime.Now.Year;
int month = DateTime.Now.Month;
int day = DateTime.Now.Day;
string password = txtPassword.EditValue.ToString().ToLower();
var ValidUser = db.Users.Where(s => s.ID == userId && s.Password.ToLower() == password).SingleOrDefault();
var _shift = db.Shifts.Where(s => s.ID == ModuleClass.shiftID).SingleOrDefault();
if (ValidUser != null)
{
if (_shift.ShiftUsers.Where(s => s.UserID == userId).Any())
{
MessageBox.Show(" للوردية " + cmbUserName.Text + " لا يمكن إضافة المسخدم ", "المستخدم موجود بالوردية");
return;
}
DataAccess.ShiftUser shiftUser = db.ShiftUsers.Create();
shiftUser.ShiftID = _shift.ID;
shiftUser.UserID = userId;
shiftUser.LogInTime = DateTime.Now;
shiftUser.LogoutTime = DateTime.Now;
shiftUser.Duration = 0;
shiftUser.Flag = 0;
_shift.ShiftUsers.Add(shiftUser);
if (db.SaveChanges() > 0)
{
var message = "" + UserData.Default.BranchName + " فرع " + " للوردية " + cmbUserName.Text + " تمت إضافة المستخدم ";
PushMessage.SendSignOnMessage(message);
MessageBox.Show(message);
Thread.Sleep(1500);
this.Close();
}
}
else
{
MessageBox.Show("الرجاء التأكد من اسم المستخدم وكلمة المرور");
}
}
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
db = ModuleClass.GetConnection();
}
}
DataAccess.RedaV1Entities db = null;//
public PushOverUC()
{
try
{
InitializeComponent();
db = ModuleClass.GetConnection();
branchBindingSource.DataSource = db.Branches.ToList();
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
}
}
static string GetTitle(int CodeID)
{
try
{
var db = ModuleClass.GetConnection();
string title = db.MessageTypes.Local.Where(s => s.CodeID == CodeID).Select(s => s.Message).SingleOrDefault().ToString();
return(title);
}
catch (Exception ex)
{
return("");
}
}
private void btnAddUser_Click(object sender, EventArgs e)
{
try
{
if (!dxErrorProvider1.HasErrors)
{
DataAccess.Request request = db.Requests.Create();
itemID = 0;
userID = Convert.ToInt32(UserData.Default.UserID);
string UserName = Convert.ToString(UserData.Default.UserName);
branchID = Convert.ToInt32(UserData.Default.BranchID);
quantity = Convert.ToInt32(txtQuantity.EditValue);
string desciption = txtDescription.Text;
request.UserID = userID;
request.BranchID = branchID;
request.RequestDate = DateTime.Now;
request.Quantity = quantity;
request.Description = desciption;
var itemObj = (ItemObject)listBoxControl1.SelectedItem;
request.ItemID = Convert.ToInt32(itemObj.Data);
db.Requests.Add(request);
if (db.SaveChanges() > 0)
{
#if !DEBUG
var message = "" + UserData.Default.BranchName + " فرع " + UserName + " من المستخدم " + lblItem.Text + " تمت طلب الصنف ";
PushMessage.SendDirectMessage(message);
#endif
MessageBox.Show("تم حفظ الطلب و إرساله للإدارة", "شكرا لاهتمامك");
// Thread.Sleep(1500);
// this.Close();
}
else
{
MessageBox.Show("توجد مشكلة في حفظ البيانات، الرجاء المحاولة مرة أخري");
}
}
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
db = ModuleClass.GetConnection();
}
}
public static bool SendPriceChangeMessage(String Message)
{
try
{
bool result = true;
var db = ModuleClass.GetConnection();
int codeId = (int)PushOverMessageType.PriceChange;
var receivers = GetReceiver(codeId);
var title = GetTitle(codeId);
result = SendPushMessage(Message, receivers, title);
return(result);
}
catch (Exception ex)
{
return(false);
}
}
public RequestItem()
{
try
{
InitializeComponent();
//string connString = ModuleClass.Connect();
//DataAccess.RedaV1Entities db = ModuleClass.GetConnection();//= new DataAccess.RedaV1Entities(ModuleClass.Connect());
db = ModuleClass.GetConnection();
Assembly executingAssembly = Assembly.GetExecutingAssembly();
AssemblyTitleAttribute assembly = executingAssembly.GetCustomAttribute <AssemblyTitleAttribute>();
AssemblyFileVersionAttribute assemblyVersion = executingAssembly.GetCustomAttribute <AssemblyFileVersionAttribute>();
/*
* DataTable dt = new DataTable();
* dt.Columns.Add("ID", typeof(int));
* dt.Columns.Add("Name", typeof(string));
*
* cmbSearch.Properties.DataSource = dt;
* cmbSearch.Properties.ValueMember = "ID";
* cmbSearch.Properties.DisplayMember = "Name";
*/
//cmbSearch.Properties.ValueMember = "ID";
// cmbSearch.Properties.DisplayMember = "Value";
//cmbSearch.Properties.PopupFilterMode = PopupFilterMode.Contains
// myLookUpEdit1.Properties.PopulateColumns();
// myLookUpEdit1.Properties.Columns[0].Visible = false;
//this.myLookUpEdit1.Properties.PopulateColumns();
db.Items.Load();
//LoadData();
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
}
}
public AddUserToShift()
{
try
{
InitializeComponent();
//string connString = ModuleClass.Connect();
//DataAccess.RedaV1Entities db = ModuleClass.GetConnection();//= new DataAccess.RedaV1Entities(ModuleClass.Connect());
db = ModuleClass.GetConnection();
DevExpress.UserSkins.BonusSkins.Register();
Assembly executingAssembly = Assembly.GetExecutingAssembly();
AssemblyTitleAttribute assembly = executingAssembly.GetCustomAttribute <AssemblyTitleAttribute>();
AssemblyFileVersionAttribute assemblyVersion = executingAssembly.GetCustomAttribute <AssemblyFileVersionAttribute>();
LoadData();
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
}
}
public AddLogin()
{
try
{
InitializeComponent();
//string connString = ModuleClass.Connect();
//DataAccess.RedaV1Entities db = ModuleClass.GetConnection();//= new DataAccess.RedaV1Entities(ModuleClass.Connect());
db = ModuleClass.GetConnection();
DevExpress.UserSkins.BonusSkins.Register();
Assembly executingAssembly = Assembly.GetExecutingAssembly();
AssemblyTitleAttribute assembly = executingAssembly.GetCustomAttribute <AssemblyTitleAttribute>();
AssemblyFileVersionAttribute assemblyVersion = executingAssembly.GetCustomAttribute <AssemblyFileVersionAttribute>();
this.Text = assembly.Title + " " + assemblyVersion.Version;// +" ( " + UserData.Default.UserName + " ) ";// +branch.BranchName;
//LoadData();
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
}
}
public static bool SendSignOutMessage(String Message)
{
try
{
bool result = true;
var db = ModuleClass.GetConnection();
int codeId = (int)PushOverMessageType.SignOut;
var receivers = GetReceiver(codeId);
var title = GetTitle(codeId);
//var message = db.MessageTypes.Local.Where(s => s.CodeID == codeId).Select(s => s.Template).SingleOrDefault().ToString();
// message = String.Format(message, Branch, date.ToString(), user);
result = SendPushMessage(Message, receivers, title);
return(result);
}
catch (Exception ex)
{
return(false);
}
}
public DollarRateForm()
{
InitializeComponent();
db = ModuleClass.GetConnection();
fillGrid();
}
private void btnNumberOfhoursToUser_Click(object sender, EventArgs e)
{
try
{
dxErrorProvider1.ClearErrors();
if (cmbUserName.EditValue == null)
{
dxErrorProvider1.SetError(cmbUserName, "يجد تحديد الموظف ");
}
if (txtHourNumbers.EditValue == "")
{
dxErrorProvider1.SetError(txtHourNumbers, "يجد تحديد عدد الساعات للموظف");
}
if (txtDescription.Text == string.Empty || txtDescription.Text == "" || txtDescription.Text == null || txtDescription.Text.Length < 7)
{
dxErrorProvider1.SetError(txtDescription, "يجد تحديد الغرض بصورة واضحة");
}
if (!dxErrorProvider1.HasErrors)
{
int userId = Convert.ToInt32(cmbUserName.EditValue);
int year = DateTime.Now.Year;
int month = DateTime.Now.Month;
int day = DateTime.Now.Day;
var message = " تمت إضافة زمن للمستخدم " + cmbUserName.Text + " لمدة " + txtHourNumbers.Text + " ساعات ";
message += " الغرض ";
message += txtDescription.Text;
string NumberOfhours = txtHourNumbers.EditValue.ToString().ToLower();
decimal balance = db.UserPayments.Where(s => s.UserID == userId).Select(s => (decimal?)s.Amount).Sum() ?? 0;
//(SELECT SUM(Amount) FROM[dbo].[UserPayment] Where UserID = @UserID)
decimal hourRate = Convert.ToDecimal(cmbUserName.GetColumnValue("HourRate"));
var _userPayment = new DataAccess.UserPayment();
_userPayment.Amount = Convert.ToDecimal(NumberOfhours) * hourRate;
_userPayment.Balance = balance + _userPayment.Amount;
_userPayment.Date = DateTime.Now;
_userPayment.Desciption = message;
_userPayment.InvoiceID = 0;
_userPayment.PaymentType = 1;
_userPayment.UserID = userId;
db.UserPayments.Add(_userPayment);
/*
* var _shift = db.Shifts.Where(s => s.BranchID == 1).OrderBy(s => s.ID).First();// .LastOrDefault();//.SingleOrDefault();
* DataAccess.ShiftUser newShift = new DataAccess.ShiftUser();
* newShift.Duration = Convert.ToDecimal(NumberOfhours) * 60;
* newShift.ShiftID = _shift.ID;
* newShift.LogInTime = DateTime.Now.AddHours(-1 * Convert.ToDouble(NumberOfhours));
* newShift.LogoutTime = DateTime.Now;
* newShift.UserID = userId;
* newShift.Flag = 1;
* db.ShiftUsers.Add(newShift);
*/
if (db.SaveChanges() > 0)
{
if (cmbUserName.GetColumnValue("PushoverID") != null)
{
string pushid = cmbUserName.GetColumnValue("PushoverID").ToString();
List <string> userIDs = new List <string>();
userIDs.Add(pushid);
var userPayment = db.UserPayments.Where(s => s.UserID == userId).OrderByDescending(s => s.ID).Take(1).SingleOrDefault();
var amount = userPayment.Amount;
balance = userPayment.Balance;
message += Environment.NewLine + " " + "القيمة " + amount + Environment.NewLine + " " + " المطالبة الحالية: " + balance + Environment.NewLine;
PushMessage.SendUserPaymentStatusMessage(message, userIDs);
MessageBox.Show(message);
Thread.Sleep(1500);
}
this.Close();
}
}
}
catch (Exception ex)
{
ModuleClass.ShowExceptionMessage(this, ex, "خطأ", null);
db = ModuleClass.GetConnection();
}
}