public JsonResult Register(WebService.Contact contact, string seria, string note, string reseller, string capcha)
{
string _msg = "";
//contact.District = "";
//contact.Province="";
contact.StoreId = StoreID.ToString();
seria = seria.Replace(" ", string.Empty).Trim();
contact.IdCard = contact.IdCard.Replace(" ", string.Empty).Trim();
string rs = service.RegisterSeria(contact, seria, reseller, note, capcha, StoreID, TokenKey, out _msg);
return(Json(new
{
code = rs,
msg = _msg
}));
}
public void SQLStore(SqlConnection conn)
{
DataTable StoreData = new DataTable();
SqlCommand SelectStore = new SqlCommand("Select * From Store Where StoreNumber = @Store and RegisterCount = @Registers", conn);
SelectStore.Parameters.AddWithValue("@Store", Workgroup);
SelectStore.Parameters.AddWithValue("@Registers", RegisterCount);
try
{
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(SelectStore);
da.Fill(StoreData);
conn.Close();
if (StoreData.Rows.Count != 0)
{
StoreID = Convert.ToInt32(StoreData.Rows[0][0]);
}
else
{
SqlCommand AddStore = new SqlCommand("Insert Into Store (StoreNumber,RegisterCount) Values (@Store,@Registers)", conn);
AddStore.Parameters.AddWithValue("@Store", Workgroup);
AddStore.Parameters.AddWithValue("@Registers", RegisterCount);
conn.Open();
AddStore.ExecuteNonQuery();
SqlDataAdapter ad = new SqlDataAdapter(SelectStore);
ad.Fill(StoreData);
ad.Dispose();
conn.Close();
StoreID = Convert.ToInt32(StoreData.Rows[0][0]);
MessageBox.Show("added store " + StoreID.ToString());
}
da.Dispose();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
}
public PartialViewResult LoadParentCategory(string[] StoreID, string ProductTypeID)
{
List <SBInventoryBaseCateGroupViewModel> lstData = new List <SBInventoryBaseCateGroupViewModel>();
if (StoreID == null)
{
StoreID = new string[] { };
}
List <string> lstStoreId = StoreID.Where(w => !string.IsNullOrEmpty(w)).ToList();
if (lstStoreId != null && lstStoreId.Any())
{
lstData = _factory.GetListCategorySortParent(lstStoreId, null, ProductTypeID, CurrentUser.ListOrganizationId);
}
SBInventoryBaseModel model = new SBInventoryBaseModel();
model.lstCateGroup = lstData;
return(PartialView("_DDLParentCategory", model));
}
public string GetKey()
{
return(StoreID.ToString() + Year.ToString());
}
public bool Save(ModelStateDictionary modelState, int userID, int employeeID)
{
if (!Validate(modelState))
{
return(Result = false);
}
QueryOutput queryResult;
var query = "";
var action = "";
var id = ID.ToString();
if (!StartDate.HasValue)
{
StartDate = DateTime.Now;
}
if (ID > 0)
{
query += String.Format(
@"update Employee
set Name = N'{0}', Address = N'{1}', Phone = N'{2}', Position = N'{3}',
Image = N'{4}', BussinessID = {5}, StoreID = {6}, StartDate = {7},
WorkTime = N'{8}', MonthlySale = {9}, BaseSalary = {10}, AdditionalSalary = {11},
WorkDays = {12}, OffDays = {13}, Summary = N'{14}', EndDate = {16},
BankNumber = N'{17}', BankName = N'{18}', BankBranch = N'{19}', WorkStatus = N'{20}', DOB = {21}
where ID = {15}", new object[] {
Name, Address, Phone, Position, Image, BussinessID, StoreID.DbValue(), StartDate.DbValue(Constants.DatabaseDateString),
WorkTime, MonthlySale, BaseSalary, AdditionalSalary, WorkDays, OffDays, Summary, ID,
EndDate.DbValue(Constants.DatabaseDateString), BankNumber, BankName, BankBranch, WorkStatus, DOB.DbValue(Constants.DatabaseDateString)
});
if (LoginID > 0)
{
query += String.Format(" update Login set EmployeeID = {0} where ID = {1}", ID, LoginID);
}
else
{
query += String.Format(" update Login set EmployeeID = null where EmployeeID = {0}", ID);
}
action = DbAction.Employee.Modify;
}
else
{
query += String.Format(@"declare @ID table (ID int)
insert Employee(Name, Address, Phone, BussinessID, StoreID, Position, Image, StartDate, WorkTime, MonthlySale, BaseSalary, AdditionalSalary, WorkDays, OffDays, Summary, Status, EndDate, BankNumber, BankName, BankBranch, WorkStatus, DOB)
output inserted.ID into @ID
values (N'{0}', N'{1}', N'{2}', {3}, {4}, N'{5}', N'{6}', {7}, N'{8}', {9}, {10}, {11}, {12}, {13}, N'{14}', 'active', {15}, N'{16}', N'{17}', N'{18}', N'{19}', {20})",
new object[] { Name, Address, Phone, BussinessID, StoreID.DbValue(), Position, Image, StartDate.DbValue(Constants.DatabaseDateString),
WorkTime, MonthlySale, BaseSalary, AdditionalSalary, WorkDays, OffDays, Summary,
EndDate.DbValue(Constants.DatabaseDateString), BankNumber, BankName, BankBranch, WorkStatus, DOB.DbValue(Constants.DatabaseDateString) });
id = "(select top 1 ID from @ID)";
if (LoginID > 0)
{
query += String.Format(" update Login set EmployeeID = (select top 1 ID from @ID) where ID = {0}", LoginID);
}
action = DbAction.Employee.Create;
}
Result = Execute(new DbQuery(userID, employeeID, action, query, true, id, "Name"), out queryResult);
if (Result)
{
Messages = new List <string>()
{
"Lưu thông tin thành công"
}
}
;
return(Result);
}
public override int GetHashCode()
{
return(ItemID.GetHashCode() + StoreID.GetHashCode());
}
protected void lvINVStore_ItemCommand(object sender, ListViewCommandEventArgs e)
{
Int64 StoreID;
Int64.TryParse(e.CommandArgument.ToString(), out StoreID);
if (StoreID > 0)
{
if (string.Equals(e.CommandName, "EditItem"))
{
_StoreID = StoreID;
PrepareEditView();
cpeEditor.Collapsed = false;
cpeEditor.ClientState = "false";
}
else if (string.Equals(e.CommandName, "DeleteItem"))
{
try
{
Int64 result = -1;
String fe = SqlExpressionBuilder.PrepareFilterExpression(INVStoreEntity.FLD_NAME_StoreID, StoreID.ToString(), SQLMatchType.Equal);
INVStoreEntity iNVStoreEntity = new INVStoreEntity();
result = FCCINVStore.GetFacadeCreate().Delete(iNVStoreEntity, fe, DatabaseOperationType.Delete, TransactionRequired.No);
if (result == 0)
{
_StoreID = 0;
_INVStoreEntity = new INVStoreEntity();
PrepareInitialView();
BindINVStoreList();
MiscUtil.ShowMessage(lblMessage, "I NVStore has been successfully deleted.", true);
}
else
{
MiscUtil.ShowMessage(lblMessage, "Failed to delete I NVStore.", true);
}
}
catch (Exception ex)
{
MiscUtil.ShowMessage(lblMessage, ex.Message, true);
}
}
}
}
