예제 #1
0
파일: WarrantyDA.cs 프로젝트: simxitnsz/RED
        public static void addWarranty(SqlCommand cmd, int invID, Warranty warranty)
        {
            string sqlCommand = "INSERT INTO Warranty (InvID, Company, StartDate, EndDate, WarrantyType, Notes) VALUES (@InvID, @Company, @StartDate, @EndDate, @WarrantyType, @Notes)";

            cmd.CommandText = sqlCommand;

            cmd.Parameters.AddWithValue("InvID", invID);
            cmd.Parameters.AddWithValue("Company", warranty.Company);
            cmd.Parameters.AddWithValue("StartDate", warranty.StartDate);
            cmd.Parameters.AddWithValue("EndDate", warranty.EndDate);
            cmd.Parameters.AddWithValue("WarrantyType", warranty.WarrantyType);
            cmd.Parameters.AddWithValue("Notes", warranty.Notes);

            cmd.ExecuteNonQuery();
            cmd.Parameters.Clear();
        }
예제 #2
0
파일: WarrantyDA.cs 프로젝트: simxitnsz/RED
        public static string addWarrantysComputer(List<int> ids, Warranty warranty)
        {
            StringBuilder message = new StringBuilder();
            SqlConnection dbConn;
            string sConnection;
            SqlCommand dbCmd;
            SqlTransaction transaction;

            sConnection = GlobalVars.ConnectionString;
            dbConn = new SqlConnection(sConnection);
            dbConn.Open();
            dbCmd = dbConn.CreateCommand();
            transaction = dbConn.BeginTransaction("Transaction");
            dbCmd.Transaction = transaction;

            try
            {
                for (int i = 0; i < ids.Count; i++)
                {
                    int invId = ids[i];

                    string sqlCommand = "INSERT INTO Warranty (InvID, Company, StartDate, EndDate, WarrantyType, Notes) VALUES (@InvID, @Company, @StartDate, @EndDate, @WarrantyType, @Notes)";

                    dbCmd.CommandText = sqlCommand;
                    dbCmd.Parameters.AddWithValue("InvID", invId);
                    dbCmd.Parameters.AddWithValue("Company", warranty.Company);
                    dbCmd.Parameters.AddWithValue("StartDate", warranty.StartDate);
                    dbCmd.Parameters.AddWithValue("EndDate", warranty.EndDate);
                    dbCmd.Parameters.AddWithValue("WarrantyType", warranty.WarrantyType);
                    dbCmd.Parameters.AddWithValue("Notes", warranty.Notes);

                    dbCmd.ExecuteNonQuery();
                    dbCmd.Parameters.Clear();
                }
                transaction.Commit();
                dbConn.Close();
                message.Append("Warranties added successfully!");
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.ToString());
                message.Append("Database Error: " + ex.ToString() + "<bR>");
                transaction.Rollback();
            }

            return message.ToString();
        }
예제 #3
0
        protected void btnAddWarranty_Click(object sender, EventArgs e)
        {
            Page.Validate("warranty");

            List<int> ids = new List<int>();
            ids = getIDs();

            Warranty war = new Warranty();
            war.Company = ddlWarrantyCompany.SelectedItem.ToString();
            war.WarrantyType = txtBoxWarrantyType.Text;
            war.StartDate = txtBoxWarrantyStartDate.Text;
            war.EndDate = txtBoxWarrantyEndDate.Text;
            war.Notes = txtBoxWarrantyNotes.Text;

            lblWarrantyMessage.Text = Warranty.addWarrantysEquipment(ids, war);
            lblWarrantyMessage.Visible = true;

            btnWarrantyMessage_ModalPopupExtender.Show();
        }
예제 #4
0
        protected void btnAddWarranty_Click(object sender, EventArgs e)
        {
            Page.Validate("warranty");
            Warranty war = new Warranty();
            war.Company = ddlWarrantyCompany.SelectedItem.ToString();
            war.WarrantyType = txtBoxWarrantyType.Text;
            war.StartDate = txtBoxWarrantyStartDate.Text;
            war.EndDate = txtBoxWarrantyEndDate.Text;
            war.Notes = txtBoxWarrantyNotes.Text;

            lblWarrantyMessage.Text = Warranty.addWarranty(Convert.ToInt32(Session["CurrentEquipment"]), war);
            lblWarrantyMessage.Visible = true;

            if (lblWarrantyMessage.Text == "Warranty added successfully!")
            {
                panelWarranty.Visible = false;
                btnAddWarranty.Visible = true;
                GridView4.Visible = true;
                GridView4.DataBind();
            }
        }
예제 #5
0
파일: Warranty.cs 프로젝트: simxitnsz/RED
 public static string addWarrantysEquipment(List<int> ids, Warranty warranty)
 {
     return WarrantyDA.addWarrantysEquipment(ids, warranty);
 }
예제 #6
0
파일: Warranty.cs 프로젝트: simxitnsz/RED
 public static string addWarrantysComputer(List<int> ids, Warranty warranty)
 {
     return WarrantyDA.addWarrantysComputer(ids, warranty);
 }
예제 #7
0
파일: Warranty.cs 프로젝트: simxitnsz/RED
 public static string addWarranty(int invID, Warranty warranty)
 {
     return WarrantyDA.addWarranty(invID, warranty);
 }
예제 #8
0
        protected void btnRemoveWarranty_Click(object sender, EventArgs e)
        {
            try
            {
                List<Warranty> warranties = new List<Warranty>();
                warranties = (List<Warranty>)Session["Warranties"];
                warranties.RemoveAt(lstBoxWarranties.SelectedIndex);

                lstBoxWarranties.Items.Clear();
                for (int i = 0; i < warranties.Count; i++)
                {
                    Warranty warranty = new Warranty();
                    warranty = (Warranty)warranties[i];
                    lstBoxWarranties.Items.Add(warranty.Company + ": " + warranty.StartDate + "-" + warranty.EndDate);
                }
                Session["Warranties"] = warranties;
            }
            catch { }
        }
예제 #9
0
        protected void btnAddWarranty_Click(object sender, EventArgs e)
        {
            Page.Validate("warranty");
            List<Warranty> warranties = new List<Warranty>();
            Warranty war = new Warranty();
            war.Company = ddlWarrantyCompany.SelectedItem.ToString();
            war.WarrantyType = txtBoxWarrantyType.Text;
            war.StartDate = txtBoxWarrantyStartDate.Text;
            war.EndDate = txtBoxWarrantyEndDate.Text;
            war.Notes = txtBoxWarrantyNotes.Text;

            if (lstBoxWarranties.Items.Count == 0)
            {
                warranties.Clear();
            }
            else
            {
                warranties = (List<Warranty>)Session["Warranties"];
            }
            warranties.Add(war);

            lstBoxWarranties.Items.Clear();
            for (int i = 0; i < warranties.Count; i++)
            {
                Warranty warranty = new Warranty();
                warranty = (Warranty)warranties[i];
                lstBoxWarranties.Items.Add(warranty.Company + ": " + warranty.StartDate + "-" + warranty.EndDate);
            }
            Session["Warranties"] = warranties;
        }