CreateExtention - Hightechrobo bin

TEXT 4

CreateExtention Guest on 14th July 2025 05:51:04 AM

public async Task CreateExtention(Extention model)
{
try
{
using (SqlConnection con = new SqlConnection(connectionString))
{
SqlCommand cmd = new SqlCommand("spExtensionInsert", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Extid", model.ExtensionId));
cmd.Parameters.Add(new SqlParameter("@Firstname", model.FirstName ?? (object)DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Lastname", model.LastName ?? (object)DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Building", model.Building ?? (object)DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Floor", model.Floor ?? (object)DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Room", model.Room ?? (object)DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Address", model.Address ?? (object)DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Description", model.Description ?? (object)DBNull.Value));
cmd.Parameters.Add(new SqlParameter("@Ringgroup", model.RingGroup ?? (object)DBNull.Value));
con.Open();
await cmd.ExecuteReaderAsync();
con.Close();
}
}
catch (Exception ex)
{
throw;
}
}

Advertise here

Recent Pastes

Raw Paste

public async Task CreateExtention(Extention model)
{
    try
    {
        using (SqlConnection con = new SqlConnection(connectionString))
        {
            SqlCommand cmd = new SqlCommand("spExtensionInsert", con);
            cmd.CommandType = CommandType.StoredProcedure;

cmd.Parameters.Add(new SqlParameter("@Extid", model.ExtensionId));
            cmd.Parameters.Add(new SqlParameter("@Firstname", model.FirstName ?? (object)DBNull.Value));
            cmd.Parameters.Add(new SqlParameter("@Lastname", model.LastName ?? (object)DBNull.Value));
            cmd.Parameters.Add(new SqlParameter("@Building", model.Building ?? (object)DBNull.Value));
            cmd.Parameters.Add(new SqlParameter("@Floor", model.Floor ?? (object)DBNull.Value));
            cmd.Parameters.Add(new SqlParameter("@Room", model.Room ?? (object)DBNull.Value));
            cmd.Parameters.Add(new SqlParameter("@Address", model.Address ?? (object)DBNull.Value));
            cmd.Parameters.Add(new SqlParameter("@Description", model.Description ?? (object)DBNull.Value));
            cmd.Parameters.Add(new SqlParameter("@Ringgroup", model.RingGroup ?? (object)DBNull.Value));

con.Open();
            await cmd.ExecuteReaderAsync();
            con.Close();

}
    }

catch (Exception ex)
    {

throw;
    }

}