public SizeGridModel GetById(int?id)
{
var body = "";
SizeGridModel SizeGridById = ServerResponse.Invoke <SizeGridModel>("api/sizeGrid/getDetail?id=" + id, body, "get");
return(SizeGridById);
}
public SizeGridModel Delete(SizeGridModel sizeGridModel)
{
var body = JsonConvert.SerializeObject(sizeGridModel);
SizeGridModel SizeGridDelete = ServerResponse.Invoke <SizeGridModel>("api/sizeGrid/Delete?id=" + sizeGridModel.Id, body, "POST");
return(SizeGridDelete);
}
public bool CheckGridNo(SizeGridModel model)
{
var body = JsonConvert.SerializeObject(model);
var CheckGridNo = ServerResponse.Invoke <bool>("api/sizeGrid/checkGridNo", body, "POST");
return(CheckGridNo);
}
public bool Create(SizeGridModel sizeGridModel)
{
var body = JsonConvert.SerializeObject(sizeGridModel);
bool SizeGridCreate = ServerResponse.Invoke <bool>("api/sizeGrid/create", body, "Post");
return(SizeGridCreate);
}
public bool Edit(SizeGridModel sizeGridModel)
{
var body = JsonConvert.SerializeObject(sizeGridModel);
bool SizeGridEdit = ServerResponse.Invoke <bool>("api/sizeGrid/edit?id=" + sizeGridModel.Id, body, "POST");
return(SizeGridEdit);
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SizeGridModel SizeGridModelById = Services.SizeGridService.GetById(id);
var dict = new Dictionary <string, string>();
var keyvalue = Utility.getKeyVaue(SizeGridModelById).Where(x => x.Key.Contains("Z")).ToList();
foreach (var item2 in keyvalue)
{
if (!string.IsNullOrEmpty(item2.Value))
{
if (item2.Value.Contains(".0"))
{
//item2[item2.Key] = item2.Value.Replace(".0", "");
dict.Add(item2.Key, item2.Value.Replace(".0", ""));
}
else
{
dict.Add(item2.Key, item2.Value);
}
}
}
ViewData["Sizes"] = dict;
return(View(SizeGridModelById));
}
public ActionResult DeleteConfirmed(SizeGridModel sizeGrid)
{
if (sizeGrid.Id > 0)
{
SizeGridModel SizeGridDelete = Services.SizeGridService.Delete(sizeGrid);
TempData["Success"] = "Data saved successfully!";
return(RedirectToAction("Index", "SizeGrid"));
}
return(View(sizeGrid));
}
public ActionResult Edit(SizeGridModel sizeGrid)
{
if (ModelState.IsValid)
{
bool SizeGridEdit = Services.SizeGridService.Edit(sizeGrid);
TempData["Success"] = "Data saved successfully!";
return(RedirectToAction("Index", "SizeGrid"));
}
return(View(sizeGrid));
}
public IHttpActionResult SizeGridAutocompleteOffer(string name)
{
SizeGridModel model = new SizeGridModel();
var data = db.SizeGrids.Where(x => x.IsActive == true);
foreach (var item in data)
{
model.Z01 = item.Z01;
}
return(Ok(data));
}
public ActionResult Create(SizeGridModel sizeGrid)
{
var errors = ModelState.Values.SelectMany(v => v.Errors);
if (ModelState.IsValid)
{
// user.IsActive = true;
bool SizeGridCreate = Services.SizeGridService.Create(sizeGrid);
TempData["Success"] = "Data saved successfully!";
return(RedirectToAction("Index", "SizeGrid"));
}
return(View(sizeGrid));
}
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SizeGridModel SizeGridModelById = Services.SizeGridService.GetById(id);
if (SizeGridModelById == null)
{
return(HttpNotFound());
}
return(View(SizeGridModelById));
}
public JsonResult getGridSize(int?id)
{
//ProductModel ProductModelById = Services.ProductService.GetById(id);
SizeGridModel SizeGridModelById = Services.SizeGridService.GetById(id);
List <string> namelist = new List <string>();
if (!string.IsNullOrEmpty(SizeGridModelById.Z01.ToString()))
{
if (SizeGridModelById.Z01.ToString().Contains(".0"))
{
var a1 = SizeGridModelById.Z01.ToString().Replace(".0", "");
namelist.Add(a1);
}
else
{
namelist.Add(SizeGridModelById.Z01.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z02.ToString()))
{
if (SizeGridModelById.Z02.ToString().Contains(".0"))
{
var a2 = SizeGridModelById.Z02.ToString().Replace(".0", "");
namelist.Add(a2);
}
else
{
namelist.Add(SizeGridModelById.Z02.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z03.ToString()))
{
if (SizeGridModelById.Z03.ToString().Contains(".0"))
{
var a3 = SizeGridModelById.Z03.ToString().Replace(".0", "");
namelist.Add(a3);
}
else
{
namelist.Add(SizeGridModelById.Z03.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z04.ToString()))
{
if (SizeGridModelById.Z04.ToString().Contains(".0"))
{
var a4 = SizeGridModelById.Z04.ToString().Replace(".0", "");
namelist.Add(a4);
}
else
{
namelist.Add(SizeGridModelById.Z04.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z05.ToString()))
{
if (SizeGridModelById.Z05.ToString().Contains(".0"))
{
var a5 = SizeGridModelById.Z05.ToString().Replace(".0", "");
namelist.Add(a5);
}
else
{
namelist.Add(SizeGridModelById.Z05.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z06.ToString()))
{
if (SizeGridModelById.Z06.ToString().Contains(".0"))
{
var a6 = SizeGridModelById.Z06.ToString().Replace(".0", "");
namelist.Add(a6);
}
else
{
namelist.Add(SizeGridModelById.Z06.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z07.ToString()))
{
if (SizeGridModelById.Z07.ToString().Contains(".0"))
{
var a7 = SizeGridModelById.Z07.ToString().Replace(".0", "");
namelist.Add(a7);
}
else
{
namelist.Add(SizeGridModelById.Z07.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z08.ToString()))
{
if (SizeGridModelById.Z08.ToString().Contains(".0"))
{
var a8 = SizeGridModelById.Z08.ToString().Replace(".0", "");
namelist.Add(a8);
}
else
{
namelist.Add(SizeGridModelById.Z08.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z09.ToString()))
{
if (SizeGridModelById.Z09.ToString().Contains(".0"))
{
var a9 = SizeGridModelById.Z09.ToString().Replace(".0", "");
namelist.Add(a9);
}
else
{
namelist.Add(SizeGridModelById.Z09.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z10.ToString()))
{
if (SizeGridModelById.Z10.ToString().Contains(".0"))
{
var a10 = SizeGridModelById.Z10.ToString().Replace(".0", "");
namelist.Add(a10);
}
else
{
namelist.Add(SizeGridModelById.Z10.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z11.ToString()))
{
if (SizeGridModelById.Z11.ToString().Contains(".0"))
{
var a11 = SizeGridModelById.Z11.ToString().Replace(".0", "");
namelist.Add(a11);
}
else
{
namelist.Add(SizeGridModelById.Z11.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z12.ToString()))
{
if (SizeGridModelById.Z12.ToString().Contains(".0"))
{
var a12 = SizeGridModelById.Z12.ToString().Replace(".0", "");
namelist.Add(a12);
}
else
{
namelist.Add(SizeGridModelById.Z12.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z13.ToString()))
{
if (SizeGridModelById.Z13.ToString().Contains(".0"))
{
var a13 = SizeGridModelById.Z13.ToString().Replace(".0", "");
namelist.Add(a13);
}
else
{
namelist.Add(SizeGridModelById.Z13.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z14.ToString()))
{
if (SizeGridModelById.Z14.ToString().Contains(".0"))
{
var a14 = SizeGridModelById.Z14.ToString().Replace(".0", "");
namelist.Add(a14);
}
else
{
namelist.Add(SizeGridModelById.Z14.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z15.ToString()))
{
if (SizeGridModelById.Z15.ToString().Contains(".0"))
{
var a15 = SizeGridModelById.Z15.ToString().Replace(".0", "");
namelist.Add(a15);
}
else
{
namelist.Add(SizeGridModelById.Z15.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z16.ToString()))
{
if (SizeGridModelById.Z16.ToString().Contains(".0"))
{
var a16 = SizeGridModelById.Z16.ToString().Replace(".0", "");
namelist.Add(a16);
}
else
{
namelist.Add(SizeGridModelById.Z16.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z17.ToString()))
{
if (SizeGridModelById.Z17.ToString().Contains(".0"))
{
var a17 = SizeGridModelById.Z17.ToString().Replace(".0", "");
namelist.Add(a17);
}
else
{
namelist.Add(SizeGridModelById.Z17.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z18.ToString()))
{
if (SizeGridModelById.Z18.ToString().Contains(".0"))
{
var a18 = SizeGridModelById.Z18.ToString().Replace(".0", "");
namelist.Add(a18);
}
else
{
namelist.Add(SizeGridModelById.Z18.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z19.ToString()))
{
if (SizeGridModelById.Z19.ToString().Contains(".0"))
{
var a19 = SizeGridModelById.Z19.ToString().Replace(".0", "");
namelist.Add(a19);
}
else
{
namelist.Add(SizeGridModelById.Z19.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z20.ToString()))
{
if (SizeGridModelById.Z20.ToString().Contains(".0"))
{
var a20 = SizeGridModelById.Z20.ToString().Replace(".0", "");
namelist.Add(a20);
}
else
{
namelist.Add(SizeGridModelById.Z20.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z21.ToString()))
{
if (SizeGridModelById.Z21.ToString().Contains(".0"))
{
var a21 = SizeGridModelById.Z21.ToString().Replace(".0", "");
namelist.Add(a21);
}
else
{
namelist.Add(SizeGridModelById.Z21.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z22.ToString()))
{
if (SizeGridModelById.Z22.ToString().Contains(".0"))
{
var a22 = SizeGridModelById.Z22.ToString().Replace(".0", "");
namelist.Add(a22);
}
else
{
namelist.Add(SizeGridModelById.Z22.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z23.ToString()))
{
if (SizeGridModelById.Z23.ToString().Contains(".0"))
{
var a23 = SizeGridModelById.Z23.ToString().Replace(".0", "");
namelist.Add(a23);
}
else
{
namelist.Add(SizeGridModelById.Z23.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z24.ToString()))
{
if (SizeGridModelById.Z24.ToString().Contains(".0"))
{
var a24 = SizeGridModelById.Z24.ToString().Replace(".0", "");
namelist.Add(a24);
}
else
{
namelist.Add(SizeGridModelById.Z24.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z25.ToString()))
{
if (SizeGridModelById.Z25.ToString().Contains(".0"))
{
var a25 = SizeGridModelById.Z25.ToString().Replace(".0", "");
namelist.Add(a25);
}
else
{
namelist.Add(SizeGridModelById.Z25.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z26.ToString()))
{
if (SizeGridModelById.Z26.ToString().Contains(".0"))
{
var a26 = SizeGridModelById.Z26.ToString().Replace(".0", "");
namelist.Add(a26);
}
else
{
namelist.Add(SizeGridModelById.Z26.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z27.ToString()))
{
if (SizeGridModelById.Z27.ToString().Contains(".0"))
{
var a27 = SizeGridModelById.Z27.ToString().Replace(".0", "");
namelist.Add(a27);
}
else
{
namelist.Add(SizeGridModelById.Z27.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z28.ToString()))
{
if (SizeGridModelById.Z28.ToString().Contains(".0"))
{
var a28 = SizeGridModelById.Z28.ToString().Replace(".0", "");
namelist.Add(a28);
}
else
{
namelist.Add(SizeGridModelById.Z28.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z29.ToString()))
{
if (SizeGridModelById.Z29.ToString().Contains(".0"))
{
var a29 = SizeGridModelById.Z29.ToString().Replace(".0", "");
namelist.Add(a29);
}
else
{
namelist.Add(SizeGridModelById.Z29.ToString());
}
}
if (!string.IsNullOrEmpty(SizeGridModelById.Z30.ToString()))
{
if (SizeGridModelById.Z30.ToString().Contains(".0"))
{
var a30 = SizeGridModelById.Z30.ToString().Replace(".0", "");
namelist.Add(a30);
}
else
{
namelist.Add(SizeGridModelById.Z30.ToString());
}
}
return(Json(namelist, JsonRequestBehavior.AllowGet));
}
public JsonResult CheckGridNo(SizeGridModel model)
{
var iExist = Services.SizeGridService.CheckGridNo(model);
return(Json(!iExist, JsonRequestBehavior.AllowGet));
}
public ActionResult ExcelUpload(SizeGridModel sizeGrid, HttpPostedFileBase ExcelFile)
{
Dictionary <int, string> GridNumber = new Dictionary <int, string>();
Dictionary <string, string> process = new Dictionary <string, string>();
Dictionary <int, SizeGridModel> sizeGrids = new Dictionary <int, SizeGridModel>();
Dictionary <int, SizeGridModel> TempsizeGrids = new Dictionary <int, SizeGridModel>();
Dictionary <int, SizeGridModel> updatesizeGrids = new Dictionary <int, SizeGridModel>();
string filePath = string.Empty;
if (ExcelFile != null)
{
string path = Server.MapPath("~/File/");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
filePath = path + Path.GetFileName(ExcelFile.FileName);
string extension = Path.GetExtension(ExcelFile.FileName);
ExcelFile.SaveAs(filePath);
string csvData = System.IO.File.ReadAllText(filePath);
var csv = csvData.Split('\n').Length;
int i = 0;
foreach (string row in csvData.Split('\n'))
{
try
{
if (!string.IsNullOrEmpty(row) && row.Split(',')[0].All(char.IsDigit) && !row.StartsWith(",,,,,"))
{
i++;
var model = new SizeGridModel();
var rowSplit = row.Split(',');
model.GridNumber = rowSplit[0].ToString();
if (model.GridNumber.Length < 2)
{
var s = model.GridNumber.Length;
while (s < 2)
{
model.GridNumber = "0" + model.GridNumber;
s++;
}
}
model.Z01 = Convert.ToInt32(rowSplit[1].ToString());
model.Z02 = Convert.ToInt32(rowSplit[2].ToString());
model.Z03 = Convert.ToInt32(rowSplit[3].ToString());
model.Z04 = Convert.ToInt32(rowSplit[4].ToString());
model.Z05 = Convert.ToInt32(rowSplit[5].ToString());
model.Z06 = Convert.ToInt32(rowSplit[6].ToString());
model.Z07 = Convert.ToInt32(rowSplit[7].ToString());
model.Z08 = Convert.ToInt32(rowSplit[8].ToString());
model.Z09 = Convert.ToInt32(rowSplit[9].ToString());
model.Z10 = Convert.ToInt32(rowSplit[10].ToString());
model.Z11 = Convert.ToInt32(rowSplit[11].ToString());
model.Z12 = Convert.ToInt32(rowSplit[12].ToString());
model.Z13 = Convert.ToInt32(rowSplit[13].ToString());
model.Z14 = Convert.ToInt32(rowSplit[14].ToString());
model.Z15 = Convert.ToInt32(rowSplit[15].ToString());
model.Z16 = Convert.ToInt32(rowSplit[16].ToString());
model.Z17 = Convert.ToInt32(rowSplit[17].ToString());
model.Z18 = Convert.ToInt32(rowSplit[18].ToString());
model.Z19 = Convert.ToInt32(rowSplit[19].ToString());
model.Z20 = Convert.ToInt32(rowSplit[20].ToString());
model.Z21 = Convert.ToInt32(rowSplit[21].ToString());
model.Z22 = Convert.ToInt32(rowSplit[22].ToString());
model.Z23 = Convert.ToInt32(rowSplit[23].ToString());
model.Z24 = Convert.ToInt32(rowSplit[24].ToString());
model.Z25 = Convert.ToInt32(rowSplit[25].ToString());
model.Z26 = Convert.ToInt32(rowSplit[26].ToString());
model.Z27 = Convert.ToInt32(rowSplit[27].ToString());
model.Z28 = Convert.ToInt32(rowSplit[28].ToString());
model.Z29 = Convert.ToInt32(rowSplit[29].ToString());
model.Z30 = Convert.ToInt32(rowSplit[30].ToString());
model.IsActive = true;
TempsizeGrids.Add(i, model);
GridNumber.Add(i, model.GridNumber);
}
}
catch (Exception ex)
{
if (ex.Message != null)
{
process[i + "#" + row.Split(',')[0]] = ex.Message;
}
else
{
process[i + "#" + row.Split(',')[0]] = "Error Adding the row";
}
}
}
}
var isexists = Services.SizeGridService.CheckGridNumber(GridNumber);
if (TempsizeGrids != null && TempsizeGrids.Count > 0)
{
foreach (var item in TempsizeGrids)
{
if (isexists[item.Key] == false)
{
sizeGrids.Add(item.Key, item.Value);
process[item.Key + "#" + item.Value.GridNumber] = "Add";
}
else
{
updatesizeGrids.Add(item.Key, item.Value);
process[item.Key + "#" + item.Value.GridNumber] = "Update";
}
}
}
var addList = Services.SizeGridService.CreateList(sizeGrids);
var updateList = Services.SizeGridService.UpdateList(updatesizeGrids);
var dictionaryFrom = new Dictionary <string, string>();
dictionaryFrom = sc.getFilterData(addList, updateList, process);
TempData["ProcessData"] = dictionaryFrom;
TempData["Success"] = "Data Uploaded Successfully!";
return(RedirectToAction("Index", "SizeGrid"));
}
