private void CreateDataTable()
{
try
{
dt = new DataTable();
dt.Columns.Add("ProductID", typeof(Int32));
dt.Columns.Add("ProductName", typeof(String));
dt.Columns.Add("ProductCode", typeof(String));
dt.Columns.Add("CategoryID", typeof(Int32));
dt.Columns.Add("CategoryName", typeof(String));
dt.Columns.Add("Spec", typeof(String));
dt.Columns.Add("Total_Qty", typeof(Double));
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dt.Columns.Add("Act_Qty_" + ds.Tables[0].Rows[i]["id"].ToString(), typeof(Double));
dt.Columns.Add("Blck_Qty_" + ds.Tables[0].Rows[i]["id"].ToString(), typeof(Double));
dt.Columns.Add("Total_Qty_" + ds.Tables[0].Rows[i]["id"].ToString(), typeof(Double));
dt.Columns.Add("Blck_Qty_Exp_" + ds.Tables[0].Rows[i]["id"].ToString(), typeof(Int32));
dt.Columns.Add("ReOrd_Qty_" + ds.Tables[0].Rows[i]["id"].ToString(), typeof(Double));
dt.Columns.Add("ReOrd_ExpDt_" + ds.Tables[0].Rows[i]["id"].ToString(), typeof(String));
}
}
catch (Exception ex)
{
PLog.Error("Error::Class > StockReport, Method >CreateDataTable()", ex);
}
}
public string HealthCheckConnection()
{
string flag = "";
SqlConnection connection = null;
try
{
connection = new SqlConnection(SQLAdapter.GetConnection());
connection.Open();
flag = "Success";
}
catch (Exception ex)
{
flag = "Error:" + ex.ToString();
PLog.Error("HealthCheck", ex, 0, "");
}
finally
{
if (connection != null && connection.State == ConnectionState.Open)
{
connection.Close();
}
}
return(flag);
}
public string SaveDocumentOUT(string Data)
{
PLog.Info("BEGIN::Controller > GridStock, Method > SaveDocumentOUT(string Data):::" + Data);
string DocName = "";
try
{
OutwardDocumentImple objModel = JsonConvert.DeserializeObject <OutwardDocumentImple>(Data);
long Flg = 0;
string[] sD = objModel.DocDate.Split('-');
objModel.DocDate = new DateTime(Convert.ToInt32(sD[2]), Convert.ToInt32(sD[1]), Convert.ToInt32(sD[0])).ToString();
if (!string.IsNullOrEmpty(objModel.EffectiveDate))
{
string[] sD1 = objModel.EffectiveDate.Split('-');
objModel.EffectiveDate = new DateTime(Convert.ToInt32(sD1[2]), Convert.ToInt32(sD1[1]), Convert.ToInt32(sD1[0])).ToString();
}
DocName = objModel.SaveDocument(out Flg);
if (Flg == -494)
{
DocName = "-494";
}
}
catch (Exception ex)
{
PLog.Error("Error::Controller >GridStock, Method > SaveDocumentOUT(string Data)", ex);
}
PLog.Info("END::Controller > GridStock, Method > SaveDocumentOUT(string Data):::" + Data);
return(DocName);
}
public string WarehouseData()
{
PLog.Info("BEGIN::Controller > GridStock, Method > WarehouseData");
List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >();
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
Dictionary <string, object> row;
try
{
IWareHouseImple oWareHouse = new WareHouseImple();
DataTable dt = oWareHouse.GetGridData(0); //0 will gets all the WareHouse data
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary <string, object>();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
}
catch (Exception ex)
{
PLog.Error("Error::Controller >GridStock, Method >WarehouseData", ex);
throw;
}
PLog.Info("END::Controller > GridStock, Method > WarehouseData");
return(serializer.Serialize(rows));
}
public string LoadStockTransferDocuments()
{
PLog.Info("BEGIN::Controller > GridStock, Method > LoadStockTransferDocuments()");
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >();
try
{
DataSet ds = new DataSet();
StockTransferImple objModel = new StockTransferImple();
ds = objModel.GetGirdData(0);//0 will get all the active StockTransfer masters data
DataTable dt = ds.Tables[0];
Dictionary <string, object> row;
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary <string, object>();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
}
catch (Exception ex)
{
PLog.Error("Error::Controller >GridStock, Method > LoadStockTransferDocuments()", ex);
}
PLog.Info("END::Controller > GridStock, Method > LoadStockTransferDocuments()");
return(serializer.Serialize(rows));
}
public ActionResult GetNextPrevDoc(string _Action, int DocType, int DocNo)
{
PLog.Info("BEGIN::Controller > GridStock, Method > GetNextPrevDoc");
CommonImple _CommonImple = new CommonImple();
if (DocType == 1)//opening stocks
{
DataSet ds = _CommonImple.GetNextPrevDocData(DocType);
int x = GetDocNo(ds, DocNo, _Action);
if (x == 0)
{
return(RedirectToAction("AddOpStock"));
}
else
{
return(RedirectToAction("UpDateOpStock", new { DocID = x }));
}
}
else if (DocType == 2)
{
DataSet ds = _CommonImple.GetNextPrevDocData(DocType);
int x = GetDocNo(ds, DocNo, _Action);
if (x == 0)
{
return(RedirectToAction("AddInStock"));
}
else
{
return(RedirectToAction("UpDateInStock", new { DocID = x }));
}
}
else if (DocType == 3)
{
DataSet ds = _CommonImple.GetNextPrevDocData(DocType);
int x = GetDocNo(ds, DocNo, _Action);
if (x == 0)
{
return(RedirectToAction("AddOutStock"));
}
else
{
return(RedirectToAction("UpdateOutStock", new { DocID = x }));
}
}
else if (DocType == 4)
{
DataSet ds = _CommonImple.GetNextPrevDocData(DocType);
int x = GetDocNo(ds, DocNo, _Action);
if (x == 0)
{
return(RedirectToAction("AddStockTransfer"));
}
else
{
return(RedirectToAction("UpDateStockTransfer", new { DocID = x }));
}
}
return(Content(""));
}
public ActionResult LoginSubmit(string email, string password, int RememberMe)
{
PLog.Info("BEGIN::Controller > Home, Method > LoginSubmit(string email, string password)");
int Flg = 0;
try
{
// str = Convert.ToInt32(str).ToString();
if (!string.IsNullOrEmpty(email) && !string.IsNullOrEmpty(password))
{
LoginImple obj = new LoginImple();
Flg = obj.CheckLogin(email, password);
if (Flg > 0)
{
CreateLoginCookies(RememberMe, email, password);
}
}
}
catch (Exception ex)
{
PLog.Error("Error::Controller > Home, Method > LoginSubmit", ex);
}
PLog.Info("END::Controller > Home, Method > LoginSubmit");
return(Content(Flg.ToString()));
}
public Task <bool> SendBuffer(byte[] data, int offset, int count)
{
PLog.LogTrace($"Sending data to {m_remote}, Data Length = {count}");
TaskCompletionSource <bool> src = new TaskCompletionSource <bool>();
if (!m_isConnected)
{
PLog.LogWarning("Failed to send. Needs to be connected before calling send");
src.SetResult(false);
return(src.Task);
}
try
{
var args = m_factory.GetEmptyArgs(); // No need to Free these, as using own buffer
args.UserToken = src;
args.RemoteEndPoint = m_remote;
args.SetBuffer(data, offset, count);
args.Completed += OnSendBufferCompleted;
if (!m_socket.SendAsync(args))
{
OnSendBufferCompleted(this, args as SocketAsyncEventArgs);
}
}
catch (Exception ex)
{
PLog.LogError(ex, $"Exception while sending data to {m_remote}");
src.SetException(ex);
}
return(src.Task);
}
public UsersModel EditUser(int ID)
{
UsersModel objUsers = new UsersModel();
try
{
DataTable dt = GetGridData(ID);
if (dt != null && dt.Rows.Count > 0)
{
objUsers.UserID = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
objUsers.Name = dt.Rows[0]["username"].ToString();
objUsers.Email = dt.Rows[0]["email"].ToString();
objUsers.Password = dt.Rows[0]["Password"].ToString();
objUsers.IsAdmin = Convert.ToBoolean(dt.Rows[0]["IsAdmin"]);
if (dt.Rows[0]["RoleID"] != DBNull.Value)
objUsers.RoleID = Convert.ToInt32(dt.Rows[0]["RoleID"].ToString());
}
}
catch (Exception ex)
{
PLog.Error("Error::Class > Users, Method > EditUser(int ID)", ex);
}
return objUsers;
}
public string SaveDocument(out long ret)
{
ret = 0; string DocName = "";
try
{
ArrayList al = new ArrayList();
al.Add(this.DocID);
al.Add(this.DocName);
al.Add(Convert.ToDateTime(this.DocDate));
al.Add(this.WareHouseId);
al.Add(this.IsExpected);
al.Add(this.CustomerId);
al.Add(this.IsExpected ? this.EffectiveDate : null);
al.Add(this.GridData);
al.Add(this.Comments);
al.Add(Convert.ToInt32(_LookUps.GetSessionObject("UserID")));
DocName = _General.Set(al, "sp_InsertUpdateOutwardDoc", out ret, 0);
}
catch (Exception ex)
{
PLog.Error("Error::Class > OutwardDocument, Method > SaveDocument(out int ret)", ex);
}
return(DocName);
}
public long SaveProducts(ProductsModel productsModel)
{
long flg = 0;
try
{
var al = new ArrayList
{
productsModel.ProductID,
productsModel.Code,
productsModel.Name,
productsModel.ProductCategory,
productsModel.Status,
productsModel.efDate,
productsModel.Spec,
productsModel.Price
};
_general.Set(al, "sp_InsertUpdateProducts", out flg);
}
catch (Exception ex)
{
PLog.Error("Error::Class > OutwardDocument, Method >SaveProducts()", ex);
}
return(flg);
}
public string LoadUsers()
{
PLog.Info("BEGIN::Controller > Home, Method > LoadUsers()");
List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >();
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
try
{
UsersImple objUsersImple = new UsersImple();
DataTable dt = objUsersImple.GetGridData(0); //0 will gets all the users data
Dictionary <string, object> row;
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary <string, object>();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
}
catch (Exception ex)
{
PLog.Error("Error::Controller > Home, Method > LoadUsers()", ex);
}
PLog.Info("END::Controller > Home, Method > LoadUsers()");
return(serializer.Serialize(rows));
}
public string SaveDocument(out long ret)
{
ret = 0; string DocName = "";
try
{
ArrayList al = new ArrayList();
al.Add(this.DocID);
al.Add(this.DocName);
al.Add(Convert.ToDateTime(this.DocDate));
al.Add(this.ToWareHouseId);
al.Add(this.FromWareHouseId);
al.Add(this.Comments);
al.Add(this.GridData);
al.Add(Convert.ToInt32(_LookUps.GetSessionObject("UserID")));
DocName = _General.Set(al, "sp_InsertUpdateStockTransfer", out ret, 0);
}
catch (Exception ex)
{
PLog.Error("Error::Class > StockTransfer, Method >SaveDocument(out int ret)", ex);
}
return(DocName);
}
static void Main(string[] args)
{
// **********************
// intialise Papillon SDK
// **********************
PLog.OpenConsoleLogger();
PapillonSDK.Initialise();
// **********************************************************
// set an image from a pixel buffer (a byte[]) and display it
//***********************************************************
int width = 600;
int height = 400;
int depth = 3;
var buf = new byte[width * height * depth];
for (int i = 0; i < buf.Length; i += depth)
{
buf[i] = 127;
buf[i + 1] = 0;
buf[i + 2] = 255;
}
PImage image = new PImage();
image.Set(buf, width, height, PImage.EPixelFormat.E_BGR8U);
image.Display("Pink", 10000);
}
public string GetProductCategory()
{
PLog.Info("BEGIN::Controller > GridStock, Method > GetProductCategory");
System.Web.Script.Serialization.JavaScriptSerializer serializer = new System.Web.Script.Serialization.JavaScriptSerializer();
List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >();
try
{
IProductsCategoryImple oProducts = new ProductsCategoryImple();
DataTable dt = oProducts.GetGridData(0); //0 will gets all the products data
Dictionary <string, object> row;
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary <string, object>();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
}
catch (Exception ex)
{
PLog.Error("Error::Controller >GridStock, Method > GetProductCategory", ex);
}
PLog.Info("END::Controller > GridStock, Method > GetProductCategory");
return(serializer.Serialize(rows));
}
public void EditDocument(int DocID)
{
DataSet ds = GetGirdData(DocID);
try
{
if (ds != null && ds.Tables.Count > 0)
{
if (ds.Tables[0] != null && ds.Tables[0].Rows.Count > 0)
{
this.DocID = DocID;
this.DocName = ds.Tables[0].Rows[0]["DocName"].ToString();
this.DocDate = ConverDate(Convert.ToDateTime(ds.Tables[0].Rows[0]["DocDate"].ToString()));
this.WareHouseId = ds.Tables[0].Rows[0]["WareHouseId"].ToString();
this.WareHouseName = ds.Tables[0].Rows[0]["WareHouseName"].ToString();
}
if (ds.Tables[1] != null && ds.Tables[1].Rows.Count > 0)
{
this.GridData = JsonConvert.SerializeObject(ds.Tables[1]);
}
}
LoadScreenControls();
}
catch (Exception ex)
{
PLog.Error("Error::Class > OpeningStock, Method > EditDocument(int DocID)", ex);
}
}
public ActionResult Login()
{
ViewBag.Message = "This is the Login Page";
PLog.Info("BEGIN::Controller > Home, Method > Login");
PLog.Info("END::Controller > Home, Method >Login");
return(View());
}
public long SaveWareHouse(WareHouseModel _WareHouseModel)
{
long flg = 0;
try
{
ArrayList al = new ArrayList();
al.Add(_WareHouseModel.WareHouseID);
al.Add(_WareHouseModel.Code);
al.Add(_WareHouseModel.Name);
al.Add(_WareHouseModel.Status);
al.Add(_WareHouseModel.efDate);
_General.Set(al, "sp_InsertUpdateWareHouse", out flg);
// flg = DAL.ExecuteSP("sp_InsertUpdateWareHouse", Params, al);
}
catch (Exception ex)
{
PLog.Error("Error::Class > WareHouse, Method >SaveWareHouse()", ex);
}
return(flg);
}
public WareHouseModel EditWareHouse(int ID)
{
WareHouseModel _WareHouseModel = new WareHouseModel();
try
{
DataTable dt = GetGridData(ID);
if (dt != null && dt.Rows.Count > 0)
{
_WareHouseModel.WareHouseID = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
_WareHouseModel.Code = dt.Rows[0]["Code"].ToString();
_WareHouseModel.Name = dt.Rows[0]["Name"].ToString();
_WareHouseModel.Status = Convert.ToInt32(dt.Rows[0]["Status"].ToString());
if (dt.Rows[0]["eDate"] == DBNull.Value)
{
_WareHouseModel.efDate = ConverDate(DateTime.Now);
}
else
{
_WareHouseModel.efDate = ConverDate(Convert.ToDateTime(dt.Rows[0]["eDate"]));
}
}
}
catch (Exception ex)
{
PLog.Error("Error::Class > WareHouse, Method > EditWareHouse(int ID)", ex);
}
return(_WareHouseModel);
}
public ProductsModel EditProdcut(int ID)
{
ProductsModel objProductsModel = new ProductsModel();
try
{
DataTable dt = GetGridData(ID);
if (dt != null && dt.Rows.Count > 0)
{
objProductsModel.ProductID = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
objProductsModel.Code = dt.Rows[0]["Code"].ToString();
objProductsModel.Name = dt.Rows[0]["Name"].ToString();
objProductsModel.ProductCategory = Convert.ToInt32(dt.Rows[0]["ProductCategoryID"].ToString());
objProductsModel.Status = Convert.ToInt32(dt.Rows[0]["Status"].ToString());
if (dt.Rows[0]["eDate"] == DBNull.Value)
{
objProductsModel.efDate = ConverDate(DateTime.Now);
}
else
{
objProductsModel.efDate = ConverDate(Convert.ToDateTime(dt.Rows[0]["eDate"]));
}
objProductsModel.Spec = dt.Rows[0]["Spec"].ToString();
objProductsModel.Price = Convert.ToDecimal(dt.Rows[0]["Price"].ToString());
}
}
catch (Exception ex)
{
PLog.Error("Error::Class > Products, Method >EditProdcut(int ID)", ex);
}
return(objProductsModel);
}
public BaseUnitTest(ITestOutputHelper testOutputHelper)
{
var factory = new LoggerFactory();
factory.AddProvider(new UnitTestLoggerProvider(testOutputHelper));
PLog.AssignLoggerFactory(factory);
}
public long SaveProducts(ProductsModel _ProductsModel)
{
long flg = 0;
try
{
ArrayList al = new ArrayList();
al.Add(_ProductsModel.ProductID);
al.Add(_ProductsModel.Code);
al.Add(_ProductsModel.Name);
al.Add(_ProductsModel.ProductCategory);
al.Add(_ProductsModel.Status);
al.Add(_ProductsModel.efDate);
al.Add(_ProductsModel.Spec);
_General.Set(al, "sp_InsertUpdateProducts", out flg);
///flg = DAL.ExecuteSP("sp_InsertUpdateProducts", Params, al);
}
catch (Exception ex)
{
PLog.Error("Error::Class > OutwardDocument, Method >SaveProducts()", ex);
}
return(flg);
}
public string Getcustomers()
{
PLog.Info("BEGIN::Controller > Home, Method >LoadWarehouses ");
List <Dictionary <string, object> > rows = new List <Dictionary <string, object> >();
try
{
ICustomerImple oCustomerImple = new CustomerImple();
DataTable dt = oCustomerImple.GetGridData(0); //0 will gets all the customers data
Dictionary <string, object> row;
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary <string, object>();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
}
catch (Exception ex)
{
PLog.Error("Error::Controller > Home, Method > LoadWarehouses()", ex);
}
PLog.Info("END::Controller > Home, Method > LoadWarehouses");
return(Newtonsoft.Json.JsonConvert.SerializeObject(rows));
}
public ActionResult Warehouse()
{
PLog.Info("BEGIN::Controller > Home, Method >Warehouse() ");
WareHouseModel objModel = new WareHouseModel();
PLog.Info("END::Controller > Home, Method > Warehouse()");
return(View(objModel));
}
public void TestPLogInitialisation()
{
Assert.NotNull(PLog.LoggerFactory);
Assert.NotNull(PLog.Logger);
Assert.NotNull(PLog.CreateLogger("UnitTestAnotherLogger"));
Assert.NotNull(PLog.CreateLogger <PLogTests>());
}
public static bool PluginInit(Plugins.PLUG_INITSTRUCT initStruct)
{
if (!Plugins._plugin_registercommand(Plugins.pluginHandle, "ERC", RegisteredCommands.ErcCommand, false))
{
PLog.WriteLine("[ERC] error registering the \"ERC\" command!");
}
return(true);
}
public static void CBCREATEPROCESS(Plugins.CBTYPE cbType, ref Plugins.PLUG_CB_CREATEPROCESS info)
{
var CreateProcessInfo = info.CreateProcessInfo.ToStruct <WAPI.CREATE_PROCESS_DEBUG_INFO>();
var modInfo = info.modInfo.ToStruct <WAPI.IMAGEHLP_MODULE64>();
var DebugFileName = info.DebugFileName.MarshalToString();
var fdProcessInfo = info.fdProcessInfo.ToStruct <WAPI.PROCESS_INFORMATION>();
PLog.WriteLine("[DotNet TEST] Create process {0}", info.DebugFileName.MarshalToString());
}
// Removing this test until test ordering is sorted out
public void TestWhenLoggerIsNull()
{
var testex = new ArgumentException("ARGEX");
var testevent = new EventId(123);
PLog.LogCritical("TEST1");
PLog.LogCritical("TEST2 {0}", "PARAM2");
PLog.LogCritical(testex, "TEST3 {0}", "PARAM3");
PLog.LogCritical(testevent, "TEST4");
PLog.LogCritical(testevent, testex, "TEST4");
testex = new ArgumentException("ARGEX");
testevent = new EventId(123);
PLog.LogDebug("TEST1");
PLog.LogDebug("TEST2 {0}", "PARAM2");
PLog.LogDebug(testex, "TEST3 {0}", "PARAM3");
PLog.LogDebug(testevent, "TEST4");
PLog.LogDebug(testevent, testex, "TEST4");
testex = new ArgumentException("ARGEX");
testevent = new EventId(123);
PLog.LogError("TEST1");
PLog.LogError("TEST2 {0}", "PARAM2");
PLog.LogError(testex, "TEST3 {0}", "PARAM3");
PLog.LogError(testevent, "TEST4");
PLog.LogError(testevent, testex, "TEST4");
testex = new ArgumentException("ARGEX");
testevent = new EventId(123);
PLog.LogInformation("TEST1");
PLog.LogInformation("TEST2 {0}", "PARAM2");
PLog.LogInformation(testex, "TEST3 {0}", "PARAM3");
PLog.LogInformation(testevent, "TEST4");
PLog.LogInformation(testevent, testex, "TEST4");
testex = new ArgumentException("ARGEX");
testevent = new EventId(123);
PLog.LogTrace("TEST1");
PLog.LogTrace("TEST2 {0}", "PARAM2");
PLog.LogTrace(testex, "TEST3 {0}", "PARAM3");
PLog.LogTrace(testevent, "TEST4");
PLog.LogTrace(testevent, testex, "TEST4");
testex = new ArgumentException("ARGEX");
testevent = new EventId(123);
PLog.LogWarning("TEST1");
PLog.LogWarning("TEST2 {0}", "PARAM2");
PLog.LogWarning(testex, "TEST3 {0}", "PARAM3");
PLog.LogWarning(testevent, "TEST4");
PLog.LogWarning(testevent, testex, "TEST4");
}
public void GetStockReportData()
{
try
{
this.ds = _General.Get(new ArrayList(), "Sp_GetStockReportData", 0);
}
catch (Exception ex)
{
PLog.Error("Error::Class > StockReport, Method > GetStockReportData()", ex);
}
}
private static void plugsetup(ref Plugins.PLUG_SETUPSTRUCT setupStruct)
{
FunctionCode.globalVars.hMenu = setupStruct.hMenu;
FunctionCode.globalVars.hMenuDisasm = setupStruct.hMenuDisasm;
FunctionCode.globalVars.hMenuDump = setupStruct.hMenuDump;
FunctionCode.globalVars.hMenuStack = setupStruct.hMenuStack;
FunctionCode.globalVars.hwndDlg = setupStruct.hwndDlg;
PLog.WriteLine(szprojectnameInfo); // Add some info of the plugin to the log
FunctionCode.PlugIn_SetUp(setupStruct);
}
