public static void AddEquipmentDetails(string type, string amount, string description)
{
DBGateway aGateway = new DBGateway();
string insertQuery =
"INSERT INTO `signalappdb`.`equipemntdescription` (`TypeId`, `Amount`, `Description`) VALUES (" + type + ", " +
amount + ", '" + description + "');";
aGateway.Insert(insertQuery);
}
public static void AddTechnicalDetails(string type, string amount, string description, string OnAirDate)
{
DBGateway aGateway = new DBGateway();
string insertQuery =
"INSERT INTO `signalappdb`.`technicaldescription` (`TypeId`, `Amount`, `Description`,`OnAirDate`) VALUES (" + type +
", " +
amount + ", '" + description + "','"+OnAirDate+"');";
aGateway.Insert(insertQuery);
}
public static void AddEquimpnetType(string typeName)
{
DBGateway aGateway = new DBGateway();
string insertType = "INSERT INTO `signalappdb`.`equipmnttype` (`TypeName`) VALUES ('" + typeName + "');";
aGateway.Insert(insertType);
}
public static void UpdateDeletePhoneUserData(string status, string id, string remarks)
{
DBGateway aGateway = new DBGateway();
string query;
if (status == "0") //delete phone
{
query = "delete from telephoneusers where id=" + id + ";";
aGateway.Delete(query);
}
else if (status == "1") //connect phone
{
query = "UPDATE `signalappdb`.`telephoneusers` SET `Status`='Connected',`ConnectedDate`='" +
DateTime.Now.ToString("yyyy-MM-dd") + "' WHERE `Id`=" + id + ";";
aGateway.Update(query);
string resolver = UtilityLibrary.GetUserId();
string resolveQuery =
"INSERT INTO `signalappdb`.`complains` (`Description`, `Status`, `MenuComplainTypeId`, `TelephoneUserId`, `ComplainDate`, `ResolvedDate`, `Remarks`, `ActionTaken`, `ResolvedBy`) VALUES ('New Connection Activation', 'Resolved', 5, " +
id + ", '" + DateTime.Now + "', 'DateTime.Now', '" + remarks + "', 'Connection Provided', '" + resolver +
"');";
aGateway.Insert(resolveQuery);
}
}
public static void DisconnectPhoneOperation(string id, DBGateway aGateway, string remarks)
{
string query;
query = "UPDATE `signalappdb`.`telephoneusers` SET `Status`='Connected',`DisconnectedDate`='" +
DateTime.Now.ToString("yyyy-MM-dd") + "' WHERE `Id`=" + id + ";";
aGateway.Update(query);
query =
"INSERT INTO deletedtelephoneusers (deletedtelephoneusers.BANumber,deletedtelephoneusers.Name,deletedtelephoneusers.RankId,deletedtelephoneusers.`Status`,deletedtelephoneusers.NewPhoneNumber,deletedtelephoneusers.Address,deletedtelephoneusers.Gender,deletedtelephoneusers.ConnectedDate,deletedtelephoneusers.DisconnectedDate) SELECT telephoneusers.BANumber,telephoneusers.Name,telephoneusers.RankId,telephoneusers.`Status`,telephoneusers.NewPhoneNumber,telephoneusers.Address,telephoneusers.Gender,telephoneusers.ConnectedDate,telephoneusers.DisconnectedDate FROM telephoneusers where telephoneusers.id=" +
id + "";
aGateway.Insert(query);
query = "delete from complains where TelephoneUserId=" + id;
aGateway.Delete(query);
query = "delete from telephoneusers where id=" + id + ";";
aGateway.Delete(query);
string resolver = UtilityLibrary.GetUserId();
string resolveQuery =
"INSERT INTO `signalappdb`.`complains` (`Description`, `Status`, `MenuComplainTypeId`, `TelephoneUserId`, `ComplainDate`, `ResolvedDate`, `Remarks`, `ActionTaken`, `ResolvedBy`) VALUES ('Connection Colsed', 'Resolved', 6, " +
id + ", '" + DateTime.Now + "', 'DateTime.Now', '" + remarks + "', 'Connection Disconnected', '" + resolver +
"');";
// aGateway.Insert(resolveQuery);
}
public static void EditComplain(TelephoneComplain aTelephoneComplain, string updateQuery)
{
string complainStatus;
DBGateway aGateway = new DBGateway();
if (aTelephoneComplain.Status == "0")
{
complainStatus = "Pending";
updateQuery = "UPDATE `signalappdb`.`complains` SET `Description`='" + aTelephoneComplain.Description +
"', `Status`='" + complainStatus + "', `MenuComplainTypeId`=" +
aTelephoneComplain.ComplainType + " WHERE `Id`=" + aTelephoneComplain.ComplainId + ";";
string updateResult = aGateway.Update(updateQuery);
}
else if (aTelephoneComplain.Status == "1")
{
Telephone aTelephone = new Telephone();
string convertedDateText = aTelephone.DMYToMDY(aTelephoneComplain.ResolvedDate);
DateTime dt = DateTime.Parse(convertedDateText);
string userName = UtilityLibrary.GetUserId();
complainStatus = "Resolved";
updateQuery = "UPDATE `signalappdb`.`complains` SET `Description`='" + aTelephoneComplain.Description +
"', `Status`='" + complainStatus + "', `Remarks`='" + aTelephoneComplain.Remarks +
"', `MenuComplainTypeId`=" + aTelephoneComplain.ComplainType + ", `ResolvedDate`='" +
dt.ToString("yyyy-MM-dd HH:mm:ss") + "', `ActionTaken`='" + aTelephoneComplain.ActionTaken +
"', `ResolvedBy`='" + userName + "' WHERE `Id`=" + aTelephoneComplain.ComplainId + ";";
//string insertQuery = "INSERT INTO `signalappdb`.`resolvedcomplains` (`Description`, `Status`, `MenuComplainTypeId`, `TelephoneUserId`, `ComplainDate`, `ResolvedDate`, `Remarks`, `ActionTaken`, `ResolvedBy`, `AllPhoneInfoID`) VALUES ('"+aTelephoneComplain.Description+"', 'resolved', "+aTelephoneComplain.ProblemTypes+", (select ), '2015-12-17 23:07:26', '2015-12-19 23:07:26', 'o', 'dd', 'maruf', 10);";
string insertQuery = "INSERT INTO `signalappdb`.`resolvedcomplains` (`Description`, `Status`, `MenuComplainTypeId`, `TelephoneUserId`,`AllPhoneInfoID`,`ComplainDate`, `ResolvedDate`, `Remarks`, `ActionTaken`, `ResolvedBy`) select description,status, MenuComplainTypeId,TelephoneUserId,AllPhoneInfoID,ComplainDate,'" +dt.ToString("yyyy-MM-dd HH:mm:ss") + "', '" + aTelephoneComplain.Remarks + "', '" + aTelephoneComplain.ActionTaken + "', '" + aTelephoneComplain.ResolveBy + "' from complains WHERE ID=" + aTelephoneComplain.ComplainId + ";";
int insertCount = aGateway.Insert(insertQuery);
string deleteQuery = "Delete From Complains where id=" + aTelephoneComplain.ComplainId + "";
string delMsg = aGateway.Delete(deleteQuery);
}
}
