public PRResp getAdmin_Roles_EmpID(PRReq objPRReq)
{
string s = "select * from tbl_Admin where OID='" + objPRReq.OID + "' and Status='" + objPRReq.Status + "' and EmpID='" + objPRReq.EmpID + "' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp getItemInventory_Manufacturer_ItemName(PRReq objPRReq)
{
string s = "select * from CIT_tbl_ItemInventory where Status!='Abandoned' and OID='" + objPRReq.OID + "' and ItemName='" + objPRReq.ItemName + "' and Manufacturer='" + objPRReq.Manufacturer + "' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
// Bhubhanshu Gurjar END
public PRResp AddItemInventory(PRReq objPRReq) // Bhubhanshu Gurjar Updated insert query according to new columns
{
string insert = "insert into CIT_tbl_ItemInventory (OID,ITID,ItemName,ItemType,Model,SerialNo,Manufacturer,ComputerNumber,DOP,Warranty,WarrantyDate,Vendor,Status,Dated,UID,UName,eFile,Bill,SectionofCenter,Price) values('" + objPRReq.OID + "','" + objPRReq.ITID + "','" + objPRReq.ItemName + "','" + objPRReq.ItemType + "','" + objPRReq.ModelType + "','" + objPRReq.SerialNo + "','" + objPRReq.Manufacturer + "','" + objPRReq.ComputerNo + "','" + objPRReq.DOP + "','" + objPRReq.Warranty + "','" + objPRReq.WarrantyDate + "','" + objPRReq.Vendor + "','" + objPRReq.Status + "','" + objPRReq.Dated + "','" + objPRReq.UID + "','" + objPRReq.UName + "','" + objPRReq.EID + "','" + objPRReq.InvoiceNumber + "','" + objPRReq.Department + "','" + objPRReq.APrice + "')";
objPRResp.Count = Connections.ProcessQuery(insert);
return(objPRResp);
}
public PRResp ProjStaffLogin(PRReq objPRReq)
{
string s = "select * from PR_tbl_ProjectStaff where EmpID='" + objPRReq.EmpID + "' and Status='" + objPRReq.Status + "' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp getAllItemInventory_ITemName_Manufacturer_AMC(PRReq objPRReq) // Bhubhanshu Gurjar added Status!='Abandoned'
{
string s = "select distinct * from CIT_tbl_ItemInventory where Status!='Abandoned' and OID='" + objPRReq.OID + "' and ItemName='" + objPRReq.ItemName + "' and Warranty='" + objPRReq.Warranty + "' and Manufacturer='" + objPRReq.Manufacturer + "' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp DelModel(PRReq objPRReq)
{
string hod = "delete from CIT_tbl_Models where MID='" + objPRReq.ID + "' ";
objPRResp.GetTable = Connections.GetTable(hod);
return(objPRResp);
}
public PRResp getAllItemInventory_ITemName_Dept_AMC(PRReq objPRReq) // Bhubhanshu Gurjar added flag1=1
{
string s = "select distinct * from CIT_tbl_InventoryMapping where Flag1=1 and Status='" + objPRReq.Status + "' and OID='" + objPRReq.OID + "' and ItemName='" + objPRReq.ItemName + "' and Warranty='" + objPRReq.Warranty + "' and DeptID='" + objPRReq.DeptID + "' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp DelItemType(PRReq objPRReq)
{
string hod = "delete from CIT_tbl_ItemType where OID='" + objPRReq.OID + "' and ITID='" + objPRReq.ITID + "' ";
objPRResp.GetTable = Connections.GetTable(hod);
return(objPRResp);
}
public PRResp ItemTypeSearch(PRReq objPRReq)
{
string s = "select * from CIT_tbl_ItemType where ItemType like '%" + objPRReq.ItemType + "%' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp getItemTypeByOID(PRReq objPRReq)
{
string s = "select * from CIT_tbl_ItemType where OID='" + objPRReq.OID + "' and Status='" + objPRReq.Status + "' and ITID='" + objPRReq.ITID + "' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp EditItemTypeByOID(PRReq objPRReq)
{
string update = "update CIT_tbl_ItemType set ItemType='" + objPRReq.ItemType + "' where OID='" + objPRReq.OID + "' and ITID='" + objPRReq.ITID + "' and Status='" + objPRReq.Status + "' ";
objPRResp.Count = Connections.ProcessQuery(update);
return(objPRResp);
}
public PRResp AddItemType(PRReq objPRReq)
{
string insert = "insert into CIT_tbl_ItemType (OID,ItemType,Status) values('" + objPRReq.OID + "','" + objPRReq.ItemType + "','" + objPRReq.Status + "')";
objPRResp.Count = Connections.ProcessQuery(insert);
return(objPRResp);
}
// Item Type
// Employee Type
public PRResp getAllHWItemTypes(PRReq objPRReq)
{
string s = "select distinct * from CIT_tbl_ItemType where Status='" + objPRReq.Status + "' and OID='" + objPRReq.OID + "' and ITID in (1,2,3,4,5,26) ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp getEmpGroupsProjectStaff(PRReq objPRReq)
{
string s = "select * from PR_tbl_EmpGroup where Status='" + objPRReq.Status + "' and OID='" + objPRReq.OID + "' and EGID='3' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp getModelByManufacturer(PRReq objPRReq)
{
string s = "select * from CIT_tbl_Models where Manufacturer='" + objPRReq.Manufacturer + "' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp getAdminData(PRReq objPRReq)
{
string s = "select * from tbl_Admin where UID='" + objPRReq.UID + "' and Status='" + objPRReq.Status + "' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp EditModelByMID(PRReq objPRReq)
{
string update = "update CIT_tbl_Models set Manufacturer='" + objPRReq.Manufacturer + "', Model='" + objPRReq.ModelType + "' where MID='" + objPRReq.ID + "' ";
objPRResp.Count = Connections.ProcessQuery(update);
return(objPRResp);
}
// CIT ItemInventory
// Models/Manufacturers Bhubhanshu Gurjar START
public PRResp getAllManufacturers(PRReq objPRReq)
{
string s = "select * from CIT_tbl_Manufacturer";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp getAllItemInventory_DeptWise_NameWise_ITID(PRReq objPRReq) // Bhubhanshu Gurjar added flag1=1
{
string s = "select distinct * from CIT_tbl_InventoryMapping where Flag1=1 and Status='" + objPRReq.Status + "' and ITID='" + objPRReq.ITID + "' and OID='" + objPRReq.OID + "' order by DeptID,Name,ItemName ASC ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp AddManufacturers(PRReq objPRReq)
{
string insert = "insert into CIT_tbl_Manufacturer (Name) values('" + objPRReq.Manufacturer + "')";
objPRResp.Count = Connections.ProcessQuery(insert);
return(objPRResp);
}
public PRResp getAllItemInventory_DeptID_ItemName(PRReq objPRReq)
{
string s = "select * from CIT_tbl_InventoryMapping where Flag1=1 and Status='" + objPRReq.Status + "' and OID='" + objPRReq.OID + "' and ItemName='" + objPRReq.ItemName + "' and DeptID='" + objPRReq.DeptID + "' order by Name";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp getManufacturersByName(PRReq objPRReq)
{
string s = "select * from CIT_tbl_Manufacturer where Name='" + objPRReq.Manufacturer + "' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp getItemInventorySerialNo(PRReq objPRReq) // Bhubhanshu Gurjar added Status!='Abandoned'
{
string s = "select distinct * from CIT_tbl_ItemInventory where Status='Idle' and OID='" + objPRReq.OID + "' and SerialNo='" + objPRReq.SerialNo + "' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp EditManufacturerByMID(PRReq objPRReq)
{
string update = "update CIT_tbl_Manufacturer set Name='" + objPRReq.Manufacturer + "' where MID='" + objPRReq.ID + "' ";
objPRResp.Count = Connections.ProcessQuery(update);
return(objPRResp);
}
// Bhubhanshu Gurjar START
public PRResp getAllItemInventory_ITemName_Status(PRReq objPRReq) // Bhubhanshu Gurjar added Status!='Abandoned'
{
string s = "select * from CIT_tbl_ItemInventory where Status='" + objPRReq.Status + "' and OID='" + objPRReq.OID + "' and ItemName='" + objPRReq.ItemName + "' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp AddModel(PRReq objPRReq)
{
string insert = "insert into CIT_tbl_Models (Model,Manufacturer) values('" + objPRReq.ModelType + "' , '" + objPRReq.Manufacturer + "')";
objPRResp.Count = Connections.ProcessQuery(insert);
return(objPRResp);
}
public PRResp SGLogin(PRReq objPRReq)
{
string s = "select * from Security_tbl_SecurityGuard where SGNo='" + objPRReq.SGNO + "' and Status='" + objPRReq.Status + "' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp getModelByMID(PRReq objPRReq)
{
string s = "select * from CIT_tbl_Models where MID='" + objPRReq.ID + "' ";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp getEmp_MonthlySalayByEmpID_Status(PRReq objPRReq)
{
string s = "select * from PR_tbl_Employee_Master_Salary where OID='" + objPRReq.OID + "' and EmpID='" + objPRReq.EmpID + "'";
objPRResp.GetTable = Connections.GetTable(s);
return(objPRResp);
}
public PRResp ReleaseMappedItem_EmpID(PRReq objPRReq) // Bhubhanshu Gurjar added query to change status to idle after releasing asset
{
string update = "update CIT_tbl_InventoryMapping set Flag1='" + objPRReq.Flag1 + "' , Returned ='" + DateTime.Now + "' where OID='" + objPRReq.OID + "' and MIID='" + objPRReq.MIID + "' and Status='" + objPRReq.Status + "' ";
objPRResp.Count = Connections.ProcessQuery(update);
update = "update CIT_tbl_ItemInventory set Status = 'Idle' where SerialNo = (Select SerialNo from CIT_tbl_InventoryMapping where MIID ='" + objPRReq.MIID + "')";
objPRResp.Count = Connections.ProcessQuery(update);
return(objPRResp);
}
