public void User_Update(string vr_UserId, string vr_UserCode, string vr_UserPassword, string vr_UserNameSurName, string vr_UserDepartment, string vr_UserTelephone, string vr_UserMail, HttpContext vr_Context)
{
Db_Connection.Open();
Db_Query.Connection = Db_Connection;
Db_Query.CommandText = "exec UserUpdate @User_Id='" + vr_UserId + "', @User_code='" + vr_UserCode + "',@User_Password='******',@UserName_Surname='" + vr_UserNameSurName + "',@User_Department='" + vr_UserDepartment + "',@User_Telephone='" + vr_UserTelephone + "',@User_Mail='" + vr_UserMail + "'";
Db_Query.ExecuteNonQuery();
vr_Context.Response.Write("<script lang='JavaScript'> alert ('Kullanıcı Güncellendi.');</script>");
Db_Connection.Close();
}
public void User_Delete(string vr_UserId, HttpContext vr_Context)
{
Db_Connection.Open();
Db_Query.Connection = Db_Connection;
Db_Query.CommandText = "exec UserDelete @User_Id='" + vr_UserId + "'";
Db_Query.ExecuteNonQuery();
vr_Context.Response.Write("<script lang='JavaScript'> alert ('Kullanıcı Silindi.');</script>");
Db_Connection.Close();
}
public void Vehicle_Delete(string vr_VehicleCode, HttpContext vr_Context)
{
Db_Connection.Open();
Db_Query.Connection = Db_Connection;
Db_Query.CommandText = "exec VehicleDelete @Vehicle_Code='" + vr_VehicleCode + "'";
Db_Query.ExecuteNonQuery();
vr_Context.Response.Write("<script lang='JavaScript'> alert ('Araç Silindi.');</script>");
Db_Connection.Close();
}
public void Customer_Delete(string vr_CustomerID, HttpContext vr_Context)
{
Db_Connection.Open();
Db_Query.Connection = Db_Connection;
Db_Query.CommandText = "Exec CustomerDelete @Customer_ID='" + vr_CustomerID + "'";
Db_Query.ExecuteNonQuery();
vr_Context.Response.Write("<script lang='JavaScript'> alert ('Müşteri Silindi.');</script>");
Db_Connection.Close();
}
public void Vehicle_Update(string vr_VehicleCode, string vr_VehiclePlate, string vr_VehicleTradeMark, string vr_VehicleModel, string vr_VehicleType, string vr_VehicleYear, string vr_VehicleColor, string vr_VehicleGear, string vr_VehicleEnginePower, string vr_VehicleEngineVolume, string vr_VehicleFuelType, int vr_VehicleLicenseNo, string vr_VehicleStatus, HttpContext vr_Context)
{
Db_Connection.Open();
Db_Query.Connection = Db_Connection;
Db_Query.CommandText = "Exec VehicleUpdate @Vehicle_Code='" + vr_VehicleCode + "', @Vehicle_Plate='" + vr_VehiclePlate + "',@Vehicle_TradeMark='" + vr_VehicleTradeMark + "',@Vehicle_Model='" + vr_VehicleModel + "',@Vehicle_Type='" + vr_VehicleType + "',@Vehicle_Year='" + vr_VehicleYear + "',@Vehicle_Color='" + vr_VehicleColor + "',@Vehicle_Gear='" + vr_VehicleGear + "',@Vehicle_EnginePower='" + vr_VehicleEnginePower + "',@Vehicle_EngineVolume='" + vr_VehicleEngineVolume + "',@Vehicle_FuelType='" + vr_VehicleFuelType + "',@Vehicle_LicenseNo='" + vr_VehicleLicenseNo + "',@Vehicle_Status='" + vr_VehicleStatus + "'";
Db_Query.ExecuteNonQuery();
vr_Context.Response.Write("<script lang='JavaScript'> alert ('Araç Güncellendi.');</script>");
Db_Connection.Close();
}
public void Customer_Update(string vr_CustomerID, string vr_CustomerTitle, string vr_CustomerProvince, string vr_CustomerDistrict, string vr_CustomerAddress, string vr_CustomerTaxAdministration, int vr_CustomerTaxNumber, string vr_CustomerTelephone, string vr_CustomerEmail, HttpContext vr_Context)
{
Db_Connection.Open();
Db_Query.Connection = Db_Connection;
Db_Query.CommandText = "Exec CustomerUpdate @Customer_ID='" + vr_CustomerID + "',@Customer_Title='" + vr_CustomerTitle + "',@Customer_Province='" + vr_CustomerProvince + "',@Customer_District='" + vr_CustomerDistrict + "',@Customer_Address='" + vr_CustomerAddress + "',@Customer_TaxAdministration='" + vr_CustomerTaxAdministration + "',@Customer_Taxnumber='" + vr_CustomerTaxNumber + "',@Customer_Telephone='" + vr_CustomerTelephone + "',@Customer_Email='" + vr_CustomerEmail + "'";
Db_Query.ExecuteNonQuery();
vr_Context.Response.Write("<script lang='JavaScript'> alert ('Müşteri Güncellendi.');</script>");
Db_Connection.Close();
}
public void Contract_Del(string vr_ContactID, HttpContext vr_Context)
{
Db_Connection.Open();
Db_Query.Connection = Db_Connection;
Db_Query.CommandText = "Exec ContractDel @Contact_ID='" + vr_ContactID + "'";
Db_Query.ExecuteNonQuery();
vr_Context.Response.Write("<script lang='JavaScript'> alert ('Sözleşme Silindi.');</script>");
Db_Connection.Close();
}
public void Contract_Update(string vr_ContactID, string vr_ContractNo, string vr_ContractStart, string vr_ContractFinish, string vr_HandingDate, string vr_VehiclePlate, int vr_CustomerCode, string vr_CustomerTitle, string vr_CustomerAuthorized, string vr_TelephoneNo, string vr_EMail, string vr_CustomerRepresentative, int vr_ContractAmount, string vr_ContractCurrency, HttpContext vr_Context)
{
Db_Connection.Open();
Db_Query.Connection = Db_Connection;
Db_Query.CommandText = "Exec ContractUpdate @Contact_ID='" + vr_ContactID + "', @Contract_No='" + vr_ContractNo + "',@Contract_Start='" + vr_ContractStart + "',@Contract_Finish='" + vr_ContractFinish + "',@Handing_Date='" + vr_HandingDate + "',@Vehicle_Plate='" + vr_VehiclePlate + "',@Customer_Code='" + vr_CustomerCode + "',@Customer_Title='" + vr_CustomerTitle + "',@Customer_Authorized='" + vr_CustomerAuthorized + "',@Telephone_No='" + vr_TelephoneNo + "',@E_Mail='" + vr_EMail + "',@Customer_Representative='" + vr_CustomerRepresentative + "',@Contract_Amount='" + vr_ContractAmount + "',@Contract_Currency='" + vr_ContractCurrency + "'";
Db_Query.ExecuteNonQuery();
vr_Context.Response.Write("<script lang='JavaScript'> alert ('Sözleşme Güncellendi.');</script>");
Db_Connection.Close();
}
public void RevenuesExpenses_Delete(string vr_VoucherNumber, HttpContext vr_Context)
{
Db_Connection.Open();
Db_Query.Connection = Db_Connection;
Db_Query.CommandText = "Exec RevenuesExpensesDel @Voucher_Number='" + vr_VoucherNumber + "'";
Db_Query.ExecuteNonQuery();
vr_Context.Response.Write("<script lang='JavaScript'> alert ('Fiş Silindi.');</script>");
Db_Connection.Close();
}
public void RevenuesExpenses_Update(string vr_VoucherNumber, string vr_VoucherDate, string vr_VoucherExplanation, int vr_VoucherAmount, string vr_VoucherCurrency, string vr_VoucherCreditDebt, int vr_VoucherPositionCode, HttpContext vr_Context)
{
Db_Connection.Open();
Db_Query.Connection = Db_Connection;
Db_Query.CommandText = "Exec RevenuesExpensesUpdate @Voucher_Number='" + vr_VoucherNumber + "',@Voucher_Date='" + vr_VoucherDate + "',@Voucher_Explanation='" + vr_VoucherExplanation + "',@Voucher_Amount='" + vr_VoucherAmount + "',@Voucher_Currency='" + vr_VoucherCurrency + "',@Voucher_CreditDebt='" + vr_VoucherCreditDebt + "',@Voucher_PositionCode='" + vr_VoucherPositionCode + "'";
Db_Query.ExecuteNonQuery();
vr_Context.Response.Write("<script lang='JavaScript'> alert ('Fiş Güncellendi.');</script>");
Db_Connection.Close();
}
public void User_Login(string vr_UserCode, string vr_UserPassword, HttpContext vr_Context)
{
Db_Connection.Open();
Db_Query.Connection = Db_Connection;
Db_Query.CommandText = "select * from UsersList";
Db_DataReader = Db_Query.ExecuteReader();
while (Db_DataReader.Read())
{
if (vr_UserCode != Db_DataReader[1].ToString() || vr_UserPassword != Db_DataReader[2].ToString())
{
vr_Context.Response.Write("<script lang='JavaScript'> alert ('Yanlış Kullanıcı Adı Veya Şifre Girişi');</script>");
}
else
{
vr_Context.Response.Redirect("Anasayfa.aspx");
}
}
Db_DataReader.Close();
Db_Connection.Close();
}
