/// <summary>
/// 重新加载列表
/// </summary>
private void ReloadNewList()
{
ProductListNew.Clear();
foreach (var item in ProductList.Skip(PosLine.ListCountProduct * (CurrentPage - 1)).Take(PosLine.ListCountProduct))
{
item.IsNavigated = false;
item.NavigateMode = 0;
ProductListNew.Add(item);
}
if (ProductListNew.Count > 0)
{
CurrentIndex = 0;
ProductListNew[CurrentIndex].IsNavigated = true;
ProductListNew[CurrentIndex].NavigateMode = 0;
}
CalcAndResetPage();
}
public async Task <IHttpActionResult> AddProduct([FromBody] List <ProductListNew> value)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var connection = new SqlConnection(sqlConnectionString))
{
connection.Open();
for (int i = 0; i < value.Count; i++)
{
var p = new ProductListNew
{
VarietyName = value[i].VarietyName,
CatTypeId = value[i].CatTypeId,
Unit = value[i].Unit,
IsLot = value[i].IsLot,
IsActive = true,
GName = value[i].GName,
AddedOn = DateTime.Now,
AddedBy = 1,
speci = value[i].speci,
GSreservre = value[i].GSreservre,
AdminComment = value[i].AdminComment,
ProductDesc = value[i].ProductDesc,
};
p.Id = connection.Query <int>(@"insert ProductMaster_New(VarietyName,CatTypeId,Unit,IsLot,IsActive,GName,AddedOn,
AddedBy,speci,GSreservre,AdminComment,ProductDesc) values (@VarietyName,@CatTypeId,@Unit,@IsLot,@IsActive,@GName,@AddedOn,
@AddedBy,@speci,@GSreservre,@AdminComment,@ProductDesc) select cast(scope_identity() as int)", p).First();
}
//var userExist = connection.Query<Product>("Select * from ProductMaster where Category_Id = @Category_Id and Product_Name =@Product_Name", new { Category_Id = value.Category_Id, Product_Name=value.Product_Name }).FirstOrDefault();
//if (userExist == null)
//{
return(Json(new { Message = "Record Inserted Successfully" }));
//}
//else
//{
// throw new ProcessException("Username already exists");
//}
}
}
public async Task <IHttpActionResult> AddSingleProduct([FromBody] ProductListNew value)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (var connection = new SqlConnection(sqlConnectionString))
{
connection.Open();
var p = new ProductListNew
{
VarietyName = value.VarietyName,
CatTypeId = value.CatTypeId,
Unit = value.Unit,
IsLot = value.IsLot,
IsActive = true,
GName = value.GName,
AddedOn = DateTime.Now,
AddedBy = 1,
speci = value.speci,
GSreservre = value.GSreservre,
AdminComment = value.AdminComment,
ProductDesc = value.ProductDesc,
};
p.Id = connection.Query <int>(@"insert ProductMaster_New(VarietyName,CatTypeId,Unit,IsLot,IsActive,GName,AddedOn,
AddedBy,speci,GSreservre,AdminComment,ProductDesc) values (@VarietyName,@CatTypeId,@Unit,@IsLot,@IsActive,@GName,@AddedOn,
@AddedBy,@speci,@GSreservre,@AdminComment,@ProductDesc) select cast(scope_identity() as int)", p).First();
return(Json(new { Message = "Record Inserted Successfully" }));
//}
//else
//{
// throw new ProcessException("Username already exists");
//}
}
}