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 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 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 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 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 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);
}
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 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 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 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 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 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 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 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 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 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.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);
}
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 void GetStockReportData()
{
try
{
this.ds = _General.Get(new ArrayList(), "Sp_GetStockReportData", 0);
}
catch (Exception ex)
{
PLog.Error("Error::Class > StockReport, Method > GetStockReportData()", ex);
}
}
public ActionResult ProductsCategoryList()
{
PLog.Info("BEGIN::Controller > Home, Method > ProductCategoryList()");
try
{
var str = LoadProductsCategory();
ViewBag.Data = str;
}
catch (Exception ex)
{
PLog.Error("Error::Controller > Home, Method > ProductCategoryList()", ex);
}
PLog.Info("END::Controller > Home, Method > ProductCategoryList()");
return(View());
}
public ActionResult UserCreation()
{
PLog.Info("BEGIN::Controller > Home, Method > UserCreation()");
UsersModel obj = null;
try
{
obj = new UsersModel();
}
catch (Exception ex)
{
PLog.Error("Error::Controller > Home, Method > UserCreation()", ex);
}
PLog.Info("END::Controller > Home, Method > UserCreation()");
return(View(obj));
}
public ActionResult AddStockTransfer()
{
PLog.Info("BEGIN::Controller > GridStock, Method > AddStockTransfer()");
StockTransferImple objModel = new StockTransferImple();
try
{
objModel.init();
}
catch (Exception ex)
{
PLog.Error("Error::Controller >GridStock, Method > AddStockTransfer()", ex);
}
PLog.Info("END::Controller > GridStock, Method > AddStockTransfer()");
return(View(objModel));
}
public ActionResult AddOutStock()
{
PLog.Info("BEGIN::Controller > GridStock, Method >AddOutStock()");
OutwardDocumentImple objModel = new OutwardDocumentImple();
try
{
objModel.init();
}
catch (Exception ex)
{
PLog.Error("Error::Controller >GridStock, Method > AddOutStock()", ex);
}
PLog.Info("END::Controller > GridStock, Method >AddOutStock()");
return(View(objModel));
}
public long DeleteUser(int UserID)
{
long flg = 0;
try
{
_General.Set(new ArrayList() { UserID }, "sp_DeleteUser", out flg);
}
catch (Exception ex)
{
PLog.Error("Error::Class > Users, Method > DeleteUser(int UserID)", ex);
}
return flg;
}
public DataTable GetGridData(int UserID)
{
DataTable dt = null;
try
{
DataSet ds = _General.Get(new ArrayList() { UserID }, "sp_GetUsersData");
dt = ds.Tables[0];
}
catch (Exception ex)
{
PLog.Error("Error::Class > Users, Method > GetGridData(int UserID)", ex);
}
return dt;
}
public ActionResult GetQuickStockReport()
{
PLog.Info("BEGIN::Controller > GridStock, Method >GetStockReport()");
StockReportImple objModel = new StockReportImple();
try
{
objModel.GetStockReportData();
objModel.GenerateReportData();
}
catch (Exception ex)
{
PLog.Error("Error::Controller >GridStock, Method > GetStockReport()", ex);
}
PLog.Info("END::Controller > GridStock, Method > GetStockReport()");
return(View(objModel));
}
public ActionResult Index()
{
PLog.Info("BEGIN::Controller > Home, Method > Users()");
string str = "";
try
{
str = LoadUsers();
ViewBag.Data = str;
}
catch (Exception ex)
{
PLog.Error("Error::Controller > Home, Method > Users()", ex);
}
PLog.Info("END::Controller > Home, Method > Users()");
return(View());
}
public DataSet GetGirdData(int DocID)
{
DataSet ds = new DataSet();
try
{
ds = _General.Get(new ArrayList()
{
DocID
}, "sp_GetOutwardDocData", 0);
}
catch (Exception ex)
{
PLog.Error("Error::Class > OutwardDocument, Method > GetGirdData(int DocID)", ex);
}
return(ds); throw new NotImplementedException();
}
public DataSet GetGirdData(int DocID)
{
DataSet ds = new DataSet();
try
{
ds = _General.Get(new ArrayList()
{
DocID
}, "sp_GetOpeningStocksData", 0);
}
catch (Exception ex)
{
PLog.Error("Error::Class > OpeningStock, Method > GetGirdData(int DocID)", ex);
}
return(ds);
}
public long DeleteWareHouse(int ProductID)
{
long flg = 0;
try
{
_General.Set(new ArrayList()
{
ProductID
}, "sp_DeleteWareHouse", out flg);
}
catch (Exception ex)
{
PLog.Error("Error::Class > WareHouse, Method > DeleteWareHouse(int ProductID)", ex);
}
return(flg);
}
