public ActionResult Manage()
{
var user = StaticData.GetUser();
if (user == "")
{
Uri action = Request.Url;
Session["Action"] = action;
return(RedirectToAction("SignIn", "User"));
}
var id = StaticData.GetIdFromQuery();
var data = buss.GetList(StaticData.GetUser(), id);
if (data.Count == 0)
{
ComputerCommon model = new ComputerCommon();
model.BreadCum = ApplicationGrid.GetBreadCum("Computer |Computer Regestration |Manage ");
return(View(model));
}
foreach (var item in data[0].Doc)
{
item.DocName = StaticData.GetDocumentPath() + (item.DocName);
}
data[0].BreadCum = ApplicationGrid.GetBreadCum("Computer |Computer Regestration |Manage ");
return(View(data[0]));
//return View();
}
public List <ComputerCommon> GetGridList(GridParam gridParam)
{
var list = new List <ComputerCommon>();
try
{
var sql = "EXEC proc_tblComputer ";
sql += " @FLAG = " + dao.FilterString("A");
sql += ",@User = "******",@Search = " + dao.FilterString(gridParam.Search);
sql += ",@DisplayLength = " + dao.FilterString(gridParam.DisplayLength.ToString());
sql += ",@DisplayStart = " + dao.FilterString(gridParam.DisplayStart.ToString());
sql += ",@SortDir = " + dao.FilterString(gridParam.SortDir);
sql += ",@SortCol = " + dao.FilterString(gridParam.SortCol.ToString());
var dt = dao.ExecuteDataTable(sql);
if (null != dt)
{
int sn = 1;
foreach (System.Data.DataRow item in dt.Rows)
{
var common = new ComputerCommon()
{
UniqueId = Convert.ToInt32(item["RowId"]),
ProductReferenceId = item["ProductReferenceId"].ToString(),
ProductDestintId = item["ProductDestintId"].ToString(),
Brand = item["Brand"].ToString(),
ProductName = item["ProductName"].ToString(),
ModelNo = item["ModelNo"].ToString(),
ProductPrice = item["ProductPrice"].ToString(),
DiscountPercent = item["DiscountPercent"].ToString(),
User = item["CreatedBy"].ToString(),
CreatedDate = item["CreatedDate"].ToString(),
FilterCount = item["FilterCount"].ToString(),
};
sn++;
list.Add(common);
}
}
return(list);
}
catch (Exception e)
{
return(list);
}
}
public List <ProductSearchCommon> ShowComputer()
{
var list = new List <ProductSearchCommon>();
var computerList = new List <ComputerCommon>();
var sql = "Exec proc_tblComputer";
sql += " @Flag = " + dao.FilterString("ShowComputer");
var dt = dao.ExecuteDataTable(sql);
if (null != dt)
{
foreach (System.Data.DataRow item in dt.Rows)
{
var table = item["TableName"].ToString();
if (table == "tblComputer")
{
var computer = new ComputerCommon()
{
ProductReferenceId = item["ProductReferenceId"].ToString(),
ProductDestintId = item["ProductDestintId"].ToString(),
ProductName = item["ProductName"].ToString(),
Brand = item["Brand"].ToString(),
OfferedPrice = item["OfferedPrice"].ToString(),
ProductPrice = item["ProductPrice"].ToString(),
DiscountPercent = item["DiscountPercent"].ToString(),
DiscountAmount = item["DiscountAmount"].ToString(),
WarrentyPeriod = item["WarrentyPeriod"].ToString(),
//ProductReviewed=item["ProductReviewed"].ToString(),
Doc1 = item["Doc1"].ToString(),
Doc2 = item["Doc2"].ToString()
};
computerList.Add(computer);
}
}
}
if (null != dt)
{
var productSearch = new ProductSearchCommon()
{
ComputerList = computerList
};
list.Add(productSearch);
}
return(list);
}
public ActionResult Manage(ComputerCommon model)
{
if (model != null)
{
model.User = StaticData.GetUser();
var response = buss.Manage(model);
var imgref = response.Id.Split(';');
model.ProductReferenceId = imgref[0];
model.ProductDestintId = imgref[1];
StaticData.SetMessageInSession(response);
if (response.ErrorCode == 1)
{
ModelState.AddModelError("", response.Message);
model.BreadCum = ApplicationGrid.GetBreadCum("Computer |Computer Regestration |Manage ");
return(View(model));
}
else if (model.Doc != null)
{
foreach (var item in model.Doc)
{
if (item.Img != null)
{
var uploaded = UploadDoc(model.ProductReferenceId, model.ProductDestintId, item.View, item.Color, item.Img, "");
if (uploaded.ErrorCode == 1)
{
StaticData.SetMessageInSession(0, "Data Saved but " + uploaded.Message);
}
}
}
}
}
return(RedirectToAction("Index"));
}
public List <ComputerCommon> GetList(string user, string id)
{
var list = new List <ComputerCommon>();
try
{
var sql = "EXEC proc_tblComputer ";
sql += " @FLAG = " + dao.FilterString((id != "0" ? "S" : "A"));
sql += ",@User = "******",@RowId = " + dao.FilterString(id.ToString());
var ds = dao.ExecuteDataset(sql);
if (null != ds.Tables[0])
{
int sn = 1;
foreach (System.Data.DataRow item in ds.Tables[0].Rows)
{
var common = new ComputerCommon()
{
UniqueId = Convert.ToInt32(item["RowId"]),
ProductReferenceId = item["ProductReferenceId"].ToString(),
ProductDestintId = item["ProductDestintId"].ToString(),
Brand = item["Brand"].ToString(),
ProductName = item["ProductName"].ToString(),
CreatedDate = item["CreatedDate"].ToString(),
ProductDescription = item["ProductDescription"].ToString(),
ModelNo = item["ModelNo"].ToString(),
PartNumbers = item["PartNumbers"].ToString(),
InTheBox = item["InTheBox"].ToString(),
Series = item["Series"].ToString(),
Color = item["Color"].ToString(),
SuitableFor = item["SuitableFor"].ToString(),
TouchScreen = item["TouchScreen"].ToString(),
Sensor = item["Sensor"].ToString(),
SoundEnhancement = item["SoundEnhancement"].ToString(),
ProcessorBrand = item["ProcessorBrand"].ToString(),
ProcessorName = item["ProcessorName"].ToString(),
ProcessorGeneration = item["ProcessorGeneration"].ToString(),
ProcessorVariant = item["ProcessorVariant"].ToString(),
ProcessorCore = item["ProcessorCore"].ToString(),
ProcessorClockSpeed = item["ProcessorClockSpeed"].ToString(),
HDDCapacity = item["HDDCapacity"].ToString(),
SSD = item["SSD"].ToString(),
SSDVersiom = item["SSDVersiom"].ToString(),
SSDCapacity = item["SSDCapacity"].ToString(),
RAM = item["RAM"].ToString(),
RAMType = item["RAMType"].ToString(),
RAMFrequency = item["RAMFrequency"].ToString(),
Cache = item["Cache"].ToString(),
RPM = item["RPM"].ToString(),
GraphicProcessor = item["GraphicProcessor"].ToString(),
GraphicProcessorBrand = item["GraphicProcessorBrand"].ToString(),
GraphicProcessorCapacity = item["GraphicProcessorCapacity"].ToString(),
GraphicProcessorGen = item["GraphicProcessorGen"].ToString(),
OpeatingSystem = item["OpeatingSystem"].ToString(),
MicIn = item["MicIn"].ToString(),
RJ45 = item["RJ45"].ToString(),
USBPort = item["USBPort"].ToString(),
HDMIPort = item["HDMIPort"].ToString(),
MultiCardSlot = item["MultiCardSlot"].ToString(),
FirePort = item["FirePort"].ToString(),
TypeCPort = item["TypeCPort"].ToString(),
ScreenSize = item["ScreenSize"].ToString(),
Resolution = item["Resolution"].ToString(),
ScreenType = item["ScreenType"].ToString(),
InternalMic = item["InternalMic"].ToString(),
Speakers = item["Speakers"].ToString(),
OtherDisplayFeature = item["OtherDisplayFeature"].ToString(),
Ethernet = item["Ethernet"].ToString(),
InternetConnectivity = item["InternetConnectivity"].ToString(),
BluetoothSuppoert = item["BluetoothSuppoert"].ToString(),
BluetoothVersion = item["BluetoothVersion"].ToString(),
WIFI = item["WIFI"].ToString(),
WIFIVersion = item["WIFIVersion"].ToString(),
WifiHotspot = item["WifiHotspot"].ToString(),
Width = item["Width"].ToString(),
Height = item["Height"].ToString(),
Depth = item["Depth"].ToString(),
Weight = item["Weight"].ToString(),
BatteryBackup = item["BatteryBackup"].ToString(),
PowerSupply = item["PowerSupply"].ToString(),
BatteryCell = item["BatteryCell"].ToString(),
BatteryRemovable = item["BatteryRemovable"].ToString(),
WebCam = item["WebCam"].ToString(),
LockPort = item["LockPort"].ToString(),
Keyboard = item["Keyboard"].ToString(),
KeyboardLight = item["KeyboardLight"].ToString(),
PointerDevice = item["PointerDevice"].ToString(),
AdditionalFeatures = item["AdditionalFeatures"].ToString(),
Quantity = item["Quantity"].ToString(),
SupplierEmail = item["SupplierEmail"].ToString(),
SupplierAddress = item["SupplierAddress"].ToString(),
SupplierContactNo = item["SupplierContactNo"].ToString(),
ProductPrice = item["ProductPrice"].ToString(),
OfferedPrice = item["OfferedPrice"].ToString(),
DiscountPercent = item["DiscountPercent"].ToString(),
DiscountAmount = item["DiscountAmount"].ToString(),
Warrenty = item["Warrenty"].ToString(),
WarrentyCondition = item["WarrentyCondition"].ToString(),
WarrentyPeriod = item["WarrentyPeriod"].ToString(),
Highlights = item["Highlights"].ToString(),
TermsAndConditions = item["TermsAndConditions"].ToString(),
QuickLinksSEOTag = item["QuickLinksSEOTag"].ToString(),
ProductReviewed = item["ProductReviewed"].ToString(),
User = item["CreatedBy"].ToString(),
};
var DocList = new List <DocumentUpload>();
if (ds.Tables.Count > 1)
{
if (null != ds.Tables[1])
{
foreach (System.Data.DataRow item2 in ds.Tables[1].Rows)
{
var Doc = new DocumentUpload()
{
View = item2["Viewof"].ToString(),
Color = item2["Color"].ToString(),
DocName = item2["DocName"].ToString(),
};
DocList.Add(Doc);
}
}
}
common.Doc = DocList;
sn++;
list.Add(common);
}
}
}
catch (Exception e)
{
return(list);
}
return(list);
}
public DbResponse Manage(ComputerCommon model)
{
try
{
var sql = "EXEC proc_tblComputer ";
sql += " @flag = " + dao.FilterString((model.UniqueId > 0 ? "U" : "I"));
sql += ",@User = "******",@RowId = " + dao.FilterString(model.UniqueId.ToString());
sql += ",@ProductReferenceId = " + dao.FilterString(model.ProductReferenceId == null ? "" : model.ProductReferenceId.ToString());
sql += ",@ProductDestintId=" + dao.FilterString(model.ProductDestintId == null ? "" : model.ProductDestintId.ToString());
sql += ",@Brand=" + dao.FilterString(model.Brand == null ? "" : model.Brand.ToString());
sql += ",@ProductName=" + dao.FilterString(model.ProductName == null ? "" : model.ProductName.ToString());
sql += ",@ModelNo =" + dao.FilterString(model.ModelNo == null ? "" : model.ModelNo.ToString());
sql += ",@PartNumbers =" + dao.FilterString(model.PartNumbers == null ? "" : model.PartNumbers.ToString());
sql += ",@InTheBox =" + dao.FilterString(model.InTheBox == null ? "" : model.InTheBox.ToString());
sql += ",@Series =" + dao.FilterString(model.Series == null ? "" : model.Series.ToString());
sql += ",@Color =" + dao.FilterString(model.Color == null ? "" : model.Color.ToString());
sql += ",@SuitableFor =" + dao.FilterString(model.SuitableFor == null ? "" : model.SuitableFor.ToString());
sql += ",@TouchScreen =" + dao.FilterString(model.TouchScreen == null ? "" : model.TouchScreen.ToString());
sql += ",@Sensor =" + dao.FilterString(model.Sensor == null ? "" : model.Sensor.ToString());
sql += ",@SoundEnhancement =" + dao.FilterString(model.SoundEnhancement == null ? "" : model.SoundEnhancement.ToString());
sql += ",@ProcessorBrand =" + dao.FilterString(model.ProcessorBrand == null ? "" : model.ProcessorBrand.ToString());
sql += ",@ProcessorName =" + dao.FilterString(model.ProcessorName == null ? "" : model.ProcessorName.ToString());
sql += ",@ProcessorGeneration =" + dao.FilterString(model.ProcessorGeneration == null ? "" : model.ProcessorGeneration.ToString());
sql += ",@ProcessorVariant =" + dao.FilterString(model.ProcessorVariant == null ? "" : model.ProcessorVariant.ToString());
sql += ",@ProcessorCore =" + dao.FilterString(model.ProcessorCore == null ? "" : model.ProcessorCore.ToString());
sql += ",@ProcessorClockSpeed =" + dao.FilterString(model.ProcessorClockSpeed == null ? "" : model.ProcessorClockSpeed.ToString());
sql += ",@HDDCapacity =" + dao.FilterString(model.HDDCapacity == null ? "" : model.HDDCapacity.ToString());
sql += ",@SSD =" + dao.FilterString(model.SSD == null ? "" : model.SSD.ToString());
sql += ",@SSDVersiom =" + dao.FilterString(model.SSDVersiom == null ? "" : model.SSDVersiom.ToString());
sql += ",@SSDCapacity =" + dao.FilterString(model.SSDCapacity == null ? "" : model.SSDCapacity.ToString());
sql += ",@RAM =" + dao.FilterString(model.RAM == null ? "" : model.RAM.ToString());
sql += ",@RAMType =" + dao.FilterString(model.RAMType == null ? "" : model.RAMType.ToString());
sql += ",@RAMFrequency =" + dao.FilterString(model.RAMFrequency == null ? "" : model.RAMFrequency.ToString());
sql += ",@Cache =" + dao.FilterString(model.Cache == null ? "" : model.Cache.ToString());
sql += ",@RPM =" + dao.FilterString(model.RPM == null ? "" : model.RPM.ToString());
sql += ",@GraphicProcessor =" + dao.FilterString(model.GraphicProcessor == null ? "" : model.GraphicProcessor.ToString());
sql += ",@GraphicProcessorBrand =" + dao.FilterString(model.GraphicProcessorBrand == null ? "" : model.GraphicProcessorBrand.ToString());
sql += ",@GraphicProcessorCapacity =" + dao.FilterString(model.GraphicProcessorCapacity == null ? "" : model.GraphicProcessorCapacity.ToString());
sql += ",@GraphicProcessorGen =" + dao.FilterString(model.GraphicProcessorGen == null ? "" : model.GraphicProcessorGen.ToString());
sql += ",@OpeatingSystem =" + dao.FilterString(model.OpeatingSystem == null ? "" : model.OpeatingSystem.ToString());
sql += ",@MicIn =" + dao.FilterString(model.MicIn == null ? "" : model.MicIn.ToString());
sql += ",@RJ45 =" + dao.FilterString(model.RJ45 == null ? "" : model.RJ45.ToString());
sql += ",@USBPort =" + dao.FilterString(model.USBPort == null ? "" : model.USBPort.ToString());
sql += ",@HDMIPort =" + dao.FilterString(model.HDMIPort == null ? "" : model.HDMIPort.ToString());
sql += ",@MultiCardSlot =" + dao.FilterString(model.MultiCardSlot == null ? "" : model.MultiCardSlot.ToString());
sql += ",@FirePort =" + dao.FilterString(model.FirePort == null ? "" : model.FirePort.ToString());
sql += ",@TypeCPort =" + dao.FilterString(model.TypeCPort == null ? "" : model.TypeCPort.ToString());
sql += ",@ScreenSize =" + dao.FilterString(model.ScreenSize == null ? "" : model.ScreenSize.ToString());
sql += ",@Resolution =" + dao.FilterString(model.Resolution == null ? "" : model.Resolution.ToString());
sql += ",@ScreenType =" + dao.FilterString(model.ScreenType == null ? "" : model.ScreenType.ToString());
sql += ",@InternalMic =" + dao.FilterString(model.InternalMic == null ? "" : model.InternalMic.ToString());
sql += ",@Speakers =" + dao.FilterString(model.Speakers == null ? "" : model.Speakers.ToString());
sql += ",@OtherDisplayFeature =" + dao.FilterString(model.OtherDisplayFeature == null ? "" : model.OtherDisplayFeature.ToString());
sql += ",@Ethernet =" + dao.FilterString(model.Ethernet == null ? "" : model.Ethernet.ToString());
sql += ",@InternetConnectivity =" + dao.FilterString(model.InternetConnectivity == null ? "" : model.InternetConnectivity.ToString());
sql += ",@BluetoothSuppoert =" + dao.FilterString(model.BluetoothSuppoert == null ? "" : model.BluetoothSuppoert.ToString());
sql += ",@BluetoothVersion =" + dao.FilterString(model.BluetoothVersion == null ? "" : model.BluetoothVersion.ToString());
sql += ",@WIFI =" + dao.FilterString(model.WIFI == null ? "" : model.WIFI.ToString());
sql += ",@WIFIVersion =" + dao.FilterString(model.WIFIVersion == null ? "" : model.WIFIVersion.ToString());
sql += ",@WifiHotspot =" + dao.FilterString(model.WifiHotspot == null ? "" : model.WifiHotspot.ToString());
sql += ",@Width =" + dao.FilterString(model.Width == null ? "" : model.Width.ToString());
sql += ",@Height =" + dao.FilterString(model.Height == null ? "" : model.Height.ToString());
sql += ",@Depth =" + dao.FilterString(model.Depth == null ? "" : model.Depth.ToString());
sql += ",@Weight =" + dao.FilterString(model.Weight == null ? "" : model.Weight.ToString());
sql += ",@BatteryBackup =" + dao.FilterString(model.BatteryBackup == null ? "" : model.BatteryBackup.ToString());
sql += ",@PowerSupply =" + dao.FilterString(model.PowerSupply == null ? "" : model.PowerSupply.ToString());
sql += ",@BatteryCell =" + dao.FilterString(model.BatteryCell == null ? "" : model.BatteryCell.ToString());
sql += ",@BatteryRemovable =" + dao.FilterString(model.BatteryRemovable == null ? "" : model.BatteryRemovable.ToString());
sql += ",@WebCam =" + dao.FilterString(model.WebCam == null ? "" : model.WebCam.ToString());
sql += ",@LockPort =" + dao.FilterString(model.LockPort == null ? "" : model.LockPort.ToString());
sql += ",@Keyboard =" + dao.FilterString(model.Keyboard == null ? "" : model.Keyboard.ToString());
sql += ",@KeyboardLight =" + dao.FilterString(model.KeyboardLight == null ? "" : model.KeyboardLight.ToString());
sql += ",@PointerDevice =" + dao.FilterString(model.PointerDevice == null ? "" : model.PointerDevice.ToString());
sql += ",@AdditionalFeatures =" + dao.FilterString(model.AdditionalFeatures == null ? "" : model.AdditionalFeatures.ToString());
sql += ",@Quantity =" + dao.FilterString(model.Quantity == null ? "" : model.Quantity.ToString());
sql += ",@OfferedPrice=" + dao.FilterString(model.OfferedPrice == null ? "" : model.OfferedPrice.ToString());
sql += ",@DiscountPercent=" + dao.FilterString(model.DiscountPercent == null ? "" : model.DiscountPercent.ToString());
sql += ",@DiscountAmount=" + dao.FilterString(model.DiscountAmount == null ? "" : model.DiscountAmount.ToString());
sql += ",@ProductPrice=" + dao.FilterString(model.ProductPrice == null ? "" : model.ProductPrice.ToString());
sql += ",@QuickLinksSEOTag=" + dao.FilterString(model.QuickLinksSEOTag == null ? "" : model.QuickLinksSEOTag.ToString());
sql += ",@Warrenty=" + dao.FilterString(model.Warrenty == null ? "" : model.Warrenty.ToString());
sql += ",@WarrentyPeriod=" + dao.FilterString(model.WarrentyPeriod == null ? "" : model.WarrentyPeriod.ToString());
sql += ",@WarrentyCondition=" + dao.FilterString(model.WarrentyCondition == null ? "" : model.WarrentyCondition.ToString());
sql += ",@ProductDescription=" + dao.FilterString(model.ProductDescription == null ? "" : model.ProductDescription.ToString());
sql += ",@TermsAndConditions=" + dao.FilterString(model.TermsAndConditions == null ? "" : model.TermsAndConditions.ToString());
sql += ",@Highlights=" + dao.FilterString(model.Highlights == null ? "" : model.Highlights.ToString());
return(dao.ParseDbResponse(sql));
}
catch (Exception ex)
{
return(dao.ExceptionDbResponse(ex.Message));
}
}
public DbResponse Manage(ComputerCommon model)
{
return(repo.Manage(model));
}
