public JsonResult SavaProviders(string entity)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
ProvidersEntity model = serializer.Deserialize <ProvidersEntity>(entity);
string id = "";
if (string.IsNullOrEmpty(model.ProviderID))
{
id = new StockBusiness().AddProviders(model.Name, model.Contact, model.MobileTele, "", model.CityCode, model.Address, model.Remark, CurrentUser.UserID, CurrentUser.AgentID, CurrentUser.ClientID);
}
else
{
bool bl = new StockBusiness().UpdateProvider(model.ProviderID, model.Name, model.Contact, model.MobileTele, "", model.CityCode, model.Address, model.Remark, CurrentUser.UserID, CurrentUser.AgentID, CurrentUser.ClientID);
if (bl)
{
id = model.ProviderID;
}
}
JsonDictionary.Add("ID", id);
return(new JsonResult
{
Data = JsonDictionary,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public ProvidersEntity GetProviderByID(string providerid)
{
DataTable dt = dal.GetProviderByID(providerid);
ProvidersEntity model = new ProvidersEntity();
if (dt.Rows.Count > 0)
{
model.FillData(dt.Rows[0]);
model.City = CommonBusiness.Citys.Where(c => c.CityCode == model.CityCode).FirstOrDefault();
}
return(model);
}
public List <ProvidersEntity> GetProviders(string clientid)
{
DataTable dt = dal.GetProviders(clientid);
List <ProvidersEntity> list = new List <ProvidersEntity>();
foreach (DataRow dr in dt.Rows)
{
ProvidersEntity model = new ProvidersEntity();
model.FillData(dr);
list.Add(model);
}
return(list);
}
static void Main(string[] args)
{
var departments = new[]
{
"Marketing",
"Finance",
"Helpdesk",
"R&D",
"HR"
};
var providers = new[]
{
"Rafiki",
"Abu",
"Jack",
"Chim Chim",
"Donkey Kong"
};
using (var context = new DatabaseContext())
{
foreach (var department in departments)
{
var dp = new DepartmentEntity
{
Id = Guid.NewGuid().ToString(),
Name = department
};
context.Departments.Add(dp);
}
foreach (var provider in providers)
{
var p = new ProvidersEntity
{
Id = Guid.NewGuid().ToString(),
Name = provider
};
context.Providers.Add(p);
}
context.SaveChanges();
}
}
public List <ProvidersEntity> GetProviders(string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientID)
{
var dal = new StockDAL();
string where = " ClientID='" + clientID + "' and Status<>9";
DataTable dt = CommonBusiness.GetPagerData("Providers", "*", where, "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <ProvidersEntity> list = new List <ProvidersEntity>();
foreach (DataRow dr in dt.Rows)
{
ProvidersEntity model = new ProvidersEntity();
model.FillData(dr);
model.City = CommonBusiness.Citys.Where(c => c.CityCode == model.CityCode).FirstOrDefault();
list.Add(model);
}
return(list);
}
public List <ProvidersEntity> GetProviders(string keyWords, int pageSize, int pageIndex, ref int totalCount, ref int pageCount, string clientid)
{
var dal = new StockDAL();
string where = " ClientID='" + clientid + "' and Status<>9";
if (!string.IsNullOrEmpty(keyWords))
{
where += " and (Name like '%" + keyWords + "%' or Contact like '%" + keyWords + "%' or MobileTele like '%" + keyWords + "%')";
}
DataTable dt = CommonBusiness.GetPagerData("Providers", "*", where, "AutoID", pageSize, pageIndex, out totalCount, out pageCount);
List <ProvidersEntity> list = new List <ProvidersEntity>();
foreach (DataRow dr in dt.Rows)
{
ProvidersEntity model = new ProvidersEntity();
model.FillData(dr);
model.City = CommonBusiness.Citys.Where(c => c.CityCode == model.CityCode).FirstOrDefault();
list.Add(model);
}
return(list);
}
public JsonResult SavaProviders(string entity)
{
JavaScriptSerializer serializer = new JavaScriptSerializer();
ProvidersEntity model = serializer.Deserialize <ProvidersEntity>(entity);
string id = "";
if (string.IsNullOrEmpty(model.ProviderID))
{
id = ProvidersBusiness.BaseBusiness.AddProviders(model.Name, model.Contact, model.MobileTele, "", model.CityCode, model.Address, model.Remark, CurrentUser.UserID, CurrentUser.ClientID);
}
else
{
bool bl = ProvidersBusiness.BaseBusiness.UpdateProvider(model.ProviderID, model.Name, model.Contact, model.MobileTele, "", model.CityCode, model.Address, model.Remark, CurrentUser.UserID, CurrentUser.ClientID);
if (bl)
{
id = model.ProviderID;
}
}
if (string.IsNullOrEmpty(id))
{
JsonDictionary.Add("status", false);
}
else
{
model.ProviderID = id;
JsonDictionary.Add("status", true);
JsonDictionary.Add("model", model);
}
return(new JsonResult
{
Data = JsonDictionary,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
