How can I Create a column in SQL SERVER where, depending on the value, debt or credit appears?

Question

Good friends, I made a program where I import data from an excel file in the sql database, this database is about values, and etc... And wanted to know if you have how to create a column where after being imported sql, automatically write in the next column if it is debit or credit Exmp:

Data Mov    Valor em EUR   Débito/Crédito
23-10-2019    -5000.00     Débito
3-1-2016      1234.50      Crédito

Do I have to program this in Asp.net or can I do it in sql? Every time I care in that table gives me the debit and credit

Code Asp.net:

 protected void Upload_Click(object sender, EventArgs e)
 {
            string excelPath = Server.MapPath("~/Nova pasta/") + Path.GetFileName(FileUpload1.PostedFile.FileName);
            string filepath = Server.MapPath("~/Nova pasta/") + Path.GetFileName(FileUpload1.FileName);
            string filename = Path.GetFileName(filepath);
            FileUpload1.SaveAs(excelPath);
            string ext = Path.GetExtension(filename);
            String strConnection = @"Data Source=PEDRO-PC\SQLEXPRESS;Initial Catalog=costumizado;Persist Security Info=True;User ID=sa;Password=1234";
            string excelConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filepath + ";Extended Properties=\"Excel 12.0 Xml;HRD=YES;IMEX=1;\"";
            OleDbConnection excelConnection = new OleDbConnection(excelConnectionString);
            OleDbCommand cmd = new OleDbCommand("Select * from [rptListaMovs_4$]", excelConnection);
            excelConnection.Open();
            cmd.ExecuteNonQuery();
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter("Select * from [rptListaMovs_4$]", strConnection);
            OleDbDataReader dReader;
            dReader = cmd.ExecuteReader();

            using (SqlBulkCopy sqlBulk = new SqlBulkCopy(strConnection))
            {
                sqlBulk.DestinationTableName = "Dados";
                sqlBulk.ColumnMappings.Add("Data Mov", "Data Mov.");
                sqlBulk.ColumnMappings.Add("Data Valor", "Data Valor");
                sqlBulk.ColumnMappings.Add("Descrição do Movimento" , "Descrição do Movimento");
                sqlBulk.ColumnMappings.Add("Valor em EUR", "Valor em EUR");
                sqlBulk.WriteToServer(dReader);
             }
             excelConnection.Close();
}

Answer 1

I’ve got it, here’s the personal solution:

ALTER TABLE dbo.Dados ADD [Debito/Credito] AS CASE WHEN [Valor em EUR] < 0 THEN 'Debito' ELSE 'Credito' END;

Answer 2

This can be solved in c#:

valor > 0? "Crédito" : "Débito"

and that "Credit/Debit" column in the database is not necessary because it is redundant, unless you have positive debit and negative credit.